Working threads | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Working threads

Here are the results for "SQL Server General: User Connections"
Avr. MinMax
04-May27023375
05-May21812333
09-May24333358
10-May2248347 The SQL Server has not sent out any message indicating "The working thread limit of 255 has been reached". We are going to deploy two databases within next month. I guess about 50 users would be added to the server users. This means that the number of new connections would be something between 100 – 150. Do I need to increase the working threads number? If yes, how much?
CanadaDBA

Surely When the maximum number of worker threads is reached, SQL Server returns the following message: The working thread limit of 255 has been reached.
consider a suitable number to increase, bacause Windows allocates stack space for each thread started by SQL Server. The default size for the stack space is 512K Deepak Kumar –An eye for an eye and everyone shall be blind
What is the memory settings on SQL?
Is it a dedicated server for SQL? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
What is the memory settings on SQL?
The memory setting is Dynamically configure SQL Server memory. There is 4GB RAM but we are increasing them to 10GB.
Is it a dedicated server for SQL?
Yes, it is.
CanadaDBA
Then you may need to test the setting worker threads as per this linkhttp://www.scalabilityexperts.com/default.asp?action=article&ID=120 for more information. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Are you sure that you have connection pooling setup correctly on your apps? Many times, people increase the worker threads because this is setup incorrectly in the first place. Remember, that increasing the possible worker threads permanently consumes resources of the server just to maintain the new worker thread allocations. I know that you post on here a lot, so I’m sure you’ve checked into this already, but no reason to not remind you. [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br /><br /><br />MeanOldDBA<br />[email protected]<br /><br />When life gives you a lemon, fire the DBA.
]]>