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.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.
No comments:
Post a Comment