verify-max-worker-threads-setting.md

title	Verify Max Worker Threads Setting | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	security
ms.topic	conceptual
helpviewer_keywords	Best Practices [Database Engine]
ms.assetid	2d94adfd-3ba1-493a-b29a-b436f9d583df
author	VanMSFT
ms.author	vanto

Verify Max Worker Threads Setting

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] 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.

Best Practices Recommendations

Set the max worker threads option to 0. This enables [!INCLUDEssNoVersion] 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

See Also

Monitor and Enforce Best Practices by Using Policy-Based Management