I know in 00 you could set this on the "Processor" tab of the "SQL Server Properties" dialog In 05, is this accomplished by unchecking the "Processor Affinity" and "I/O Affinity" checkboxes for processor #2 on the "Processors" page of Maximum worker threads 0 allows SQL Server to dynamically set the number of worker threads This setting is best for most systems However, depending on your system configuration, setting this option to a specific value sometimes improves performance For more information, see Configure the max worker threads Server Configuration OptionDECLARE @ErrorLog nvarchar (512); Exploring Sql Server 00 Configuration Properties Sqlservercentral Sql server properties processors