How can I tell what value of "max worker threads" is?
Microsoft say that if the "max worker threads" option is set to 0, then SQL "automatically configure the number of worker threads at startup" (
http://msdn.microsoft.com/en-us/library/ms187024.aspx). I have set "max worker threads" to 0. How can I tell what value SQL Server has automatically configured and is running with? Note that running sp_configure shows "max worker threads" with both config_value and run_value as 0.
The answer is in the same link that you have given >The default value for max worker threads, 0, allows SQL Server to automatically configure the number of worker threads at startup. This setting is best for most systems; however, depending on your system configuration, setting max worker threads to a specific value sometimes improves performance. >The following table shows the automatically configured number of max worker threads for various combinations of CPUs and versions of SQL Server. Number of CPUs 32-bit computer 64-bit computer