SQL Counter: Part 2 (Processor Queue Length)
System Object -> Processor Queue LengthWatch the value over a sustained period of time to see if the CPU is a bottleneck. The counter measures how many threads are waiting for processor time. The count includes all threads that are "ready" and not waiting on some other thing such as I/O to complete. The general rule of thumb is that this value should be less than two times the number of processors in the system. If it is growing over time and the CPU % is greater than 80%, more or faster processors are probably needed.