I have an issue recently that I will get kicked out of gateway whenever I switch to a view page. Not only that, but it would also pull a huge amount of CPU (ranging from 88% to 99%). Even after closing the perspective window, it still pulling that same amount of CPU so the only solution I have right now is ending the task in task manager. I have increased the memory on the Designer Launcher and my VM. What is the best approach to go about this?
The most common cause of such is circular bindings. One value changes, referenced by another, then another, then another, then typically a script property change that writes to the first. Or worse, a spreading circle.
You'll have to study the bindings on disk to work out the data flow and make sure it only goes one way. Nothing at the beginning of a flow should reference downstream props.
What if it is only a specific screen and it has never happened before till this week? Nothing has been changed and I wonder if that still applies
This claim is not likely, based on your own description. Something changed, if it used to work.
It seemed to be doing that on pages with rolling lives tables. I wonder if it is something with the amount of limits I set in the SQL?
Perhaps, but you would see a corresponding change in workload in your database (which should be a separate server in production).