June 10, 2010 at 6:34 am
One of my sqlbox has CPU usage high
SQL Server instance "Dimo" is currently using 90.31% of the CPU.
SQL Server CPU Usage (Percent): Percentage of CPU Time used by the SQL Server instance out of the total on the SQL Server computer.
Any help in how to reduce the CPU usage is Appreciated.
June 10, 2010 at 7:54 am
In order to reduce CPU usage, you need to know what is causing the usage to go so high. I'd suggest using the wait states to identify which processes are causing the load to go up. Use this white paper from Microsoft as a starting point.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 10, 2010 at 7:55 am
Also asked here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=145834
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply