Results 1 to 2 of 2

Thread: High CPU Usage

  1. #1
    Join Date
    Oct 2005
    Posts
    3

    Unanswered: High CPU Usage

    COLOR=Blue]Hi all,

    What can be the reason there is a high CPU usage even when there's only 1 database being accessed. As a result the database is really really slow.
    CPU\performance usage goes as high as 100% and I can't for the life of me figure out what's causing it. The indexes are being rebuilt 3/4 times a week and I've checked to make sure there aren't any locks or anything.

    Any other ideas? [/COLOR]

    Thanks
    B.

  2. #2
    Join Date
    May 2002
    Posts
    299
    a burst of usage is normal. if you have an intensive query, the it will require the resource to complete its work. take a look at sp_lock, sp_who2 to quickly spot the offending spid/statement.
    --
    -oj
    http://www.rac4sql.net

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •