Archive for 'SDR-W6'
THREADPOOL waits high after upgrade from SQL2000
You may be inadvertently limiting the number of worker threads available to the SQL Server process. This could be caused from the ‘max worker threads’ option being set to 255 after the upgrade of the SQL Server 2000 instance to a later version of SQL Server. On SQL Server 2000, the default setting for ‘max [...]
Posted: March 23rd, 2011 under SDR-W6, Wait Stats.
Tags: max worker threads, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server Performance, THREADPOOL, Wait Stats
Comments: none
