Results 1 to 4 of 4

Thread: SQL server CPU utilization

  1. 10-23-2005, 03:54 PM #1
    kit_reddy
    kit_reddy is offline Registered User
    Join Date
    Oct 2005
    Posts
    5

    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!
    Reply With Quote Reply With Quote
  2. 10-23-2005, 07:53 PM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    what software?

    First find out what is causing that 70% utilization. Usually when you run your maintenance plan your cpu utilization shoots up.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 10-23-2005, 08:38 PM #3
    kit_reddy
    kit_reddy is offline Registered User
    Join Date
    Oct 2005
    Posts
    5
    it is Microsoft operation manager 2005
    Reply With Quote Reply With Quote
  4. 10-24-2005, 09:33 AM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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