Article ID: 2157129 - View products that this article applies to.
The default value of 'max worker threads' is 0 for SQL Server. It is not recommended to change this default value but rather allow SQL Server to dynamically determine the value at startup depending on the platform and number of logical CPUs detected.
The 'max worker threads' configuration value determines the maximum number of worker threads created for handling SQL Server requests. If the 'max worker thread' configuration value is 0, the maximum worker thread value is calculated based on platform (x86 or x64) and the number of CPUs
detected. More details on the calculation can be found in the SQL Server Books Onilne under the section titled max worker threads option
In SQL Server 2008 R2 and later versions, a lower bound is enforced. In scenarios where the "max worker thread" is set to a lower value, an error message that resembles the following may be displayed:
Msg 5862, Level 16, State 1, Procedure sp_configure, Line 166
The number of max worker threads is set too low. On this computer, the number must be more than 255. You should increase the number of max worker threads.
You can find what value SQL Server has automatically selected for 'max worker threads' by running the following query:
For more information about the products or tools that automatically check for this condition on your instance of SQL Server and on the versions of the SQL Server product, see the following table:
Collapse this tableExpand this table
Article ID: 2157129 - Last Review: August 9, 2012 - Revision: 4.0
Contact us for more help