Home Forums SQL Server 2005 Administering Max Worker Threads Setting in SQLServer RE: Max Worker Threads Setting in SQLServer

  • November 22, 2010 at 3:11 am

    #1253638

    Thanks, But it would be better to set max worker threads to 288 as per the below link and also default setting for SQLServer2005 is 0.

    http://sqlblogcasts.com/blogs/thepremiers/archive/2007/05/17/max-worker-threads-configuration-in-sql-server-2005.aspx

    Note: we have 32-bit O/s,SQLServer2005 and 8 processors(32 GB Memory).

    Please advise.

    Thanks and Regards,

    Ravichandra.