March 24, 2010 at 11:29 pm
Hello Experts,
Frequently one of our production server is experiencing high CPU usage, it almost reached 80-90 % at times.
Can anyone let me know from the sql server point of view what are the things need to consider for troubleshooting the issue.
Regards,
Sandhya
March 24, 2010 at 11:51 pm
Hi Sandhya,
If you are struggling with High CPU uses then it might be a problem in production environment, according to the best practice or suggested by Microsoft you have to identify Is there any other application is also running or not if its running on same box and consuming CPU then its better to move it to some different location or box.
As Microsoft recommended only SQl Server related stuffs needs to be there in production environment.
Regards,
Nitin Gupta
Thanks & Regards,
Nitin Gupta
SQl Server (7.0,2000,2005) - Sr. DBA
HCL Technologies, India
March 25, 2010 at 1:01 am
sandhyarao49 (3/24/2010)
Hello Experts,Frequently one of our production server is experiencing high CPU usage, it almost reached 80-90 % at times.
Can anyone let me know from the sql server point of view what are the things need to consider for troubleshooting the issue.
Regards,
Sandhya
Have faced the problem always are any particular period.
1.How many processor the server have?
2.Find which processes is taking high cpu (Other than sql)
3.Find which query is taking high cup using DMV
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply