Verify Max Worker Threads Setting

 

Applies To: SQL Server 2016

This rule checks the max worker threads server option for potentially incorrect settings. Setting the max worker threads option to a small value may prevent enough threads from servicing incoming client requests in a timely manner and could lead to "thread starvation". However, setting the option to a large value can waste address space, because each active thread consumes up to 4 MB on 64-bit servers.

Set the max worker threads option to 0. This enables SQL Server to automatically determine the correct number of active worker threads based on user requests.

Configure the max worker threads Server Configuration Option

Monitor and Enforce Best Practices by Using Policy-Based Management

Community Additions

ADD
Show: