Returns the number of threads in the ready state on all processors.
This counter needs to be divided by the number of processors on the server. If this value exceeds 10 per processor frequently and is correlated with high Processor % Usage Time further investigation is required.
- Determine whether the CPU activity is coming from SQL Server. Use tools such as Windows Performance Monitor or Task Manager to check for other programs on the server consuming CPU (e.g. anti-virus, IIS, etc.). If these programs are utilizing CPU take any needed measures to reduce the CPU activity or move the applications off the server
- Indexing, look for high CPU queries. Reduce sorting and hash operations
- Upgrade CPU capacity
- Ensure Windows Power Plan is set to High Performance
- For virtual servers ensure that the host is not oversubscribed