Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CanadaDBA
583 Posts |
 Posted - 2005-05-11 : 10:44:17
|
Here are the results for "SQL Server General: User Connections" Avr. Min Max04-May 270 23 37505-May 218 12 33309-May 243 33 35810-May 224 8 347 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? Canada DBA |
|
|
madness
Starting Member
13 Posts |
Posted - 2005-05-11 : 18:02:18
|
| The default of 255 worker threads should be fine. Once you have more than 255 connections then connections start sharing a worker thread. The 255 worker threads are allocated evenly over the cpu's of the server. You can have thousands of connection using 255 worker threads. |
 |
|
|
|
|
|
Working threads