Hi Friends,

Inspired by Rahul’s post, here are 2 more scripts that can help in detecting CPU pressure

The above query gives you a high-level view of which currently cached batches or procedures are using the most CPU.

The following query gives you time spent by workers in RUNNABLE state.

You can use the value of above query and compare with your baseline to see if there is any major difference. In fact, you can build a trend analysis on this value.

Hope this helps. Note: There are many such queries you can find here;