[sims] Narrow down CPU usage?

[Steve21]

Morning All,

 

Is there any special SQL wizardry (or SIMs but guessing SQL) that you can do to find out who and what processes in SIMs are eating CPU?

 

Just seems this year our server is running specifically high on resources and nothing has changed apart from standard updates etc over Summer.

 

Even running 8 vCPU it's running up to max capacity at certain times of the day, and while it could just be something silly like people using quick refreshing homepage widgets would be nice to find out what's eating so much. (Task Mgr wise it just shows SQL so it's nothing third party based)

 

Example below:

 

 

Steve

Edited February 19, 2018 by Steve21