December 9, 2008 at 9:09 pm
Hi Friends
Yesterday I was facing some problem in Production Server. Suddenly SQL Server performance was too high. It was almost 97% - 98%. So I restarted the sql server services then the cpu usage came to normal 20%-40%.
what could be the reason? why it went suddenly too high?
Thanks
Priyank
December 9, 2008 at 9:20 pm
A query can cause CPU to run to 100% easily. It's not abnormal to have CPU jump to 100% for short periods of time.
If it lasts longer than 5 minutes, than it is something to investigate.
December 9, 2008 at 10:16 pm
Poorly written queries can easily cause CPU to jump.
If the application hangs, you might want to set up a Profiler trace, start doing some of the things that were being done the last time and then see what is causing the issue.
This requires some detective work. There is no easy way for us to predict what might have caused this.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply