Hi Everyone
I get the following alert frequently, when iam monitoring the server with the software provided by microsoft
SQL server CPU utilization is > 70% for sometime.
Can someone please tel me what to do in order to correct this error.
Thanks!
Printable View
Hi Everyone
I get the following alert frequently, when iam monitoring the server with the software provided by microsoft
SQL server CPU utilization is > 70% for sometime.
Can someone please tel me what to do in order to correct this error.
Thanks!
what software?
First find out what is causing that 70% utilization. Usually when you run your maintenance plan your cpu utilization shoots up.
it is Microsoft operation manager 2005
Run sp_who2 on sql to see which process uses most cpu time and what kind of query the process runs.