June 22, 2008 at 8:01 am
Hi,
i use Windows 2003 64BIT SP2 ENT + SQL Server 2005 64BIT DEV.
I've about 450 users connections.
my max worker threads is currently the default = 0.
should i change it? or keep it as it is?
THX
June 22, 2008 at 8:46 am
THere is no definite rule about changing the default values:but yes thread pooling can help optimize performance, if you are getting congested on connecton, try increasing it to 2048 on 64 bit SQL Server.. using sp_configure, then reconfigure with override.
HOw many Processors do you have?
Maninder
www.dbanation.com
June 22, 2008 at 9:34 am
I thought I had read in a blog about changing this with newer servers that have multiple cores. There was some ratio of worker threads to cores that you could use. Something to do with schedulers per thread.
However I've heard in the past from PSS that this shouldn't be adjusted without a good reason. In other words, if the server is performing well, you wouldn't change this and if it's not, you'd need to specifically narrow things down to issues with threads.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
June 22, 2008 at 10:28 am
2xeon 3.0GHZ with HT enabled
June 22, 2008 at 12:29 pm
Steve is right,. What kind of issues are you having with the Server, is it related to connections or Timeouts etc..
Check out more in BOL, and go through the literature in details, before going for the change...
Maninder
www.dbanation.com
June 23, 2008 at 2:23 am
Hi,
DISABLE HT on your machine.
Regards,
Slawek
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply