SQL Counter: Part 2 (Processor Queue Length) January 4th, 2008

Vinod Kumar

System Object -> Processor Queue Length
Watch 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.

Tags: , ,

This entry was posted on Friday, January 4th, 2008 at 14:00 and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply