SQL Server Performance

Working threads

Discussion in 'General DBA Questions' started by CanadaDBA, May 11, 2005.

  1. CanadaDBA New Member

    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
  2. deepakontheweb New Member


    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
  3. satya Moderator

    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.
  4. CanadaDBA New Member

    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
  5. satya Moderator

  6. derrickleggett New Member

    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 />derrickleggett@hotmail.com<br /><br />When life gives you a lemon, fire the DBA.

Share This Page