What CPU utilization should be considered high for SQL Server? those. 80% 90% 100%?
If, under normal loads, the CPU exceeds 40% on average, I get nervous. However, this is because I know the nature of our traffic and the bursts that we receive. Your mileage may vary.
In fact, we aim even lower, by about 7-10% on average, but sometimes we get processing that will increase us to 60%.
30 , , 2% , , .
, :)
It really depends on your car. It's best to monitor the server with perfmon and see when everything starts to run slowly. For SQL, it is normal to use to load a large number of CPUs.
As a rule, you do not want the machine to support a constant processor of more than 40 or 50%, since it will not be able to handle bursts of activity.