Verify max worker threads setting
Applies to:
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 SQL Server 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
Geri Bildirim
https://aka.ms/ContentUserFeedback.
Çok yakında: 2024 boyunca, içerik için geri bildirim mekanizması olarak GitHub Sorunları’nı kullanımdan kaldıracak ve yeni bir geri bildirim sistemiyle değiştireceğiz. Daha fazla bilgi için bkz.Gönderin ve geri bildirimi görüntüleyin