Max Degree of Parallelism for SQL SERVER 2012 (before installing Sharepoint 2013)

SQL Server

Now that you have SQL Server all installed there is one more configuration change you need to do in order to make SharePoint happy. You need to change the max degree of parallelism. Don’t ask me what that is. Something about number of processors and how SQL uses them. Unfortunately SQL Server defaults to 0 and SharePoint 2013 necessitates, demands, forces, requires, and otherwise really wants you to set it to 1. So make the change. If you are running SharePoint 2010 this change is not required but is recommended.

Now if you look at the link I gave you saw a bunch of fancy SQL to change it. Barf! Let’s change it the easy way, with a mouse.

From your newly installed SQL Server click Start > All Programs > Microsoft SQL Server 2012 > SQL Server Management 2012.

On the Connect to Server screen click Connect. If for some reason the Server name: field is blank you would just type in the name of the server.

Max Degree of Parallelism 1

At the top of the Object Explorer window you see your server. Right click on it.

Max Degree of Parallelism 2

From the menu that appears click Properties.

Max Degree of Parallelism 3

In the Select a page section click Advanced.

Max Degree of Parallelism 4

Scroll to the bottom and change Max Degree of Parallelism from 0 to 1.

Max Degree of Parallelism 5

Click OK.

That does it. No need to reboot or anything else to make the change take effect.


One thought on “Max Degree of Parallelism for SQL SERVER 2012 (before installing Sharepoint 2013)”

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s