max worker threads

Question

max worker threads

Mad-Dog

SSCertifiable

Points: 6117
More actions
June 22, 2008 at 8:01 am

#129664

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

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

MannySingh SSChampion Points: 12465 More actions · Answer 1

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

Steve Jones - SSC Editor SSC Guru Points: 736160 More actions · Answer 2

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.