verify-max-worker-threads-setting.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords
Verify Max Worker Threads Setting	Verify Max Worker Threads Setting	VanMSFT	vanto	12/15/2023	sql	security	reference	Best Practices [Database Engine]

Verify max worker threads setting

[!INCLUDE SQL Server]

This rule checks the max worker threads server option for potentially incorrect settings. Setting the max worker threads option to a small value might 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.

Best practices recommendations

Set the max worker threads option to 0. This enables [!INCLUDE ssNoVersion] to automatically determine the correct number of active worker threads based on user requests.

For more information

Configure the max worker threads (server configuration option)

Related content

• Monitor and Enforce Best Practices by Using Policy-Based Management