SharePoint 2013 and Maximum Degree of Parallelism
Maximum Degree of Parallelism (MAXDOP) is a SQL server instance level setting that defines the number of processors used for the execution of a query in a parallel plan. It defines the computing and thread resources used for query plan operators that perform the work in parallel. Although many of the solutions using SQL server as a database back-end may profit from the parallelism, SharePoint is one of the solutions that works best when the parallel execution is turned off (MAXDOP=1). For SharePoint 2007 and 2010, it is the recommended setting; however, for SharePoint 2013, it is a hard requirement
How to Fix it?
- Open Microsoft SQL Server Management Studio
- Login with System Administrator user
- Right Click on instance name and select properties >> Advanced
- Change Max Degree of Parallelism to 1
- Restart the SQL Service