Max Worker Threads setting in X64 system.

Hi All,

As we know, the default max worker thread in SQL 2005 is 0. The default value for Max worker threads, 0, allows SQL Server to automatically configure the number of worker threads AT STARTUP.

http://msdn2.microsoft.com/en-us/library/ms187024.aspx

However, what's the actual max worker thread while the "max worker thread" option is configured as 0? Is it the one list in this table?

Number of CPUs

32-bit computer

64-bit computer

<= 4 processors

256

512

8 processors

288

576

16 processors

352

704

32 processors

480

960

This table is got form the above article. Please kindly help me confirm

This is the formula that SQL uses is it is at 0.

x86

<= 4 procs = 256

> 4 procs = 256+((# procs-4)*8)

x64

<= 4 procs = 512

> 4 procs = 512+((# procs-4)*16)

It is also wise to set this back to 0 if it is an upgrade from 2000.

|||Thanks a lot for your confirmation and formula!