High cpu usage analysis
Flavio
Posts: 4 New member
I'm using sql monitor version 7, and sometimes i get some high cpu usage on sql server that i'm investigating.
Is there any best practice to find the cause of the high cpu, i can get the time, the number of transaction, etc, but i cannot find any usable information to find the machine/ process/query that is creating the cpu spike for a long time.
Thanks for any information that can help me.
Flavio
Is there any best practice to find the cause of the high cpu, i can get the time, the number of transaction, etc, but i cannot find any usable information to find the machine/ process/query that is creating the cpu spike for a long time.
Thanks for any information that can help me.
Flavio
Tagged:
Comments
Thanks for posting.
There is already a discussion on this that may help you in the SQL Monitor 7 forum linked below.
https://forum.red-gate.com/discussion/comment/145648#Comment_145648
If this still does not solve your issue then please get in touch and we can investigate further.