-
SQL server CPU utilization
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.
Last edited by rmiao; 10-24-2005 at 09:36 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|