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 |
|
munkdogg
Yak Posting Veteran
53 Posts |
 Posted - 2009-01-28 : 10:39:41
|
| As part of an ongoing performance audit on one of our primary SQL boxes (8 cpu, 64bit Win2k3/64bit SQL 2k5), I've noticed the user connect+ions routinely exceeds the "default" number of worker threads per this server build.I'm considering re-configuring this option to exceed the maximum number of connections we typically see on this box. This would bump it up from 576 to 1024 (max is 922, but some threshold beyond that seems prudent).Has anyone seen good results of making such a change to their systems?Thanks to all! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-28 : 10:44:23
|
| Please read this before you change:http://blogs.msdn.com/khen1234/archive/2005/11/07/489778.aspx |
 |
|
|
munkdogg
Yak Posting Veteran
53 Posts |
Posted - 2009-01-28 : 11:00:50
|
quote:
Originally posted by sodeep
Please read this before you change:http://blogs.msdn.com/khen1234/archive/2005/11/07/489778.aspx
Very informative article, thank you!I'm going to continue monitoring this using DBCC SQLPERF(umsstats) to confirm if these results are user and/or worker connections. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-28 : 11:13:44
|
Good  . |
|
|
|
|
|
|
Configuring Max Worker Threads