Look for symptoms of high blocking or contention problems with workers if the wait count and times are high. Consider increasing the max worker thread only if the default setting is anything but zero.

Occurs when a task is waiting to be run on. This can indicate that the maximum worker setting is too low, or that batch executions are taking unusually long, thus reducing the number of workers available to satisfy other batches.


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