Monitor individual CPU cores and not just avg CPU as a whole
AVG CPU is not enough of an indication of how things are going - There could be an entire numa node maxed at 100% while other nodes are almost idle and it will drag the avg down.
As per here: https://forum.red-gate.com/discussion/comment/162141#Comment_162141
13
votes
-
Mark Jones
commented
This will be very handy to have as it will help identify situations where parallelism costs are set to high and a single node may be overutilised causing CPU starvation on a single node - increasing signal waits and slowing down queries.