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.


No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |