How to check Max Worker Threads in SQL Server 2005
We've had a few performance incidents in SQL Server 2005 and I want to check the Max Worker Threads. Would someone explain how to return that? Thanks.
Moderator Note: This is a user submitted question
Software/Hardware used:
Software/Hardware used:
ASKED:
March 19, 2009 7:08 PM
UPDATED:
March 21, 2009 9:25 PM
Answer Wiki:
This code will show you the min value, max value, config value and running value. The running value is the value which is currently in use. A value of 0 means that SQL Server will dynamically select the number of worker threads to use. This is the default setting.
<pre>exec sp_configure 'show adv', 1
reconfigure
go
exec sp_configure 'max worker threads'
go</pre>
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
