FAQ Topics

All FAQ's

General DBA

General Developer

DBA Performance Tuning

Developer Performance Tuning

Clustering

Error Messages

Write for Us

Share you SQL Server knowledge with others and raise your profile in the community More...

We have recently added a second processor to our SQL Server box. How can I configure it to take advantage of the new processor?

You don't have to do anything, assuming none of the default SQL Server settings have been changed. SQL Server will automatically take advantage of all the CPUs in your server.

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.