Hi all,
What is the maximum CPU utilization for SQL SERVER to function properly. our server's CPU utilization is touching an averrage of 70-80 % is it ok?
What can be the result of CPU utilization touching 80+ constantly?
This can be a very long answer, and much of it depends on what you are trying to achieve.
In general, you want to leverage the resources you have, the fact that you are using 80% of CPU tells me you still have 20% more to work w/ and implies you can still continue to increase the workload.
Key is to understand the usage over a period of time. If you see that over a period of high activity, you see that CPU is at 80% then you are fine. However if you are expecting workloads to increase then you will need to understand CPU usage in regards to your workloads.
And since CPU is shared by all apps, if this machine is not dedicated SQL machine, then you need to also look at CPU usage by other apps.
Thank You
Ajay
|||Actually, 75% - 80% is generally regarded as the maximum efficient usage of a CPU. After 80%, the CPU starts to become bogged down with scheduling threads, and other workload management tasks. This server is in trouble. Run a trace, and check for queries that are using more than 1,000 reads. Some of these may be tunable with indexes, or possibly re-writing them to use existing indexes.|||This blog post is relevant: http://blogs.msdn.com/slavao/archive/2006/09/28/776437.aspx
Thanks, Ron D.
No comments:
Post a Comment