The OS Processor Queue Length (Count) alert indicates that the number of threads waiting on the processor reached an alert threshold. A consistently high processor queue length can indicate processor congestion. If your system has multiple processors, you may need to increase your alert thresholds.

Reduce your OS processor queue length

If the Processor Queue Length is often high, consider making one of the following changes:

  • Upgrade to faster CPU(s).
  • Reduce the number of SQL re-compilations as they are CPU intensive. There are many reasons that an object such as a stored procedure is recompiled, and you can remove most of these reasons by careful coding. See the SQL re-compilations counter for ways to dramatically reduce recompiles.
  • Stop unnecessary programs from running (such as the Print Spooler or activities such as the database server acting as either a BDC or PDC).

To enable alerting when this metric is outside its established baseline, click the Baseline Thresholds Enabled (as percentage of baseline) check box in the Alert Configuration window.

SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >