We have recently added a second processor to our SQL Server box. How can I configure it to take advantage of the new processor?
To find out how your SQL Server is currently configured, right-click on the server in Enterprise Manger or Management Studio, and select “Properties”. Next, select the “Processor Tab” from the “SQL Server Properties” dialog box.
Here, you should see an option under “Parallelism” called “Use all available processors”. By default, after installing SQL Server, this option is selected. When this option is selected, SQL Server will automatically take advantage of all the CPUs in your server. The other option user “Parallelism” is “Use x processor(s)”, where the x refers to the number of processors in your server.
If this option is selected, and the number of processors selected is less than the number of processors in your server, then not all of the processors will be used by SQL Server. If this is the case, then you will want to change this option, and select “Use all available processors” instead.