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?

  1. Open Microsoft SQL Server Management Studio
  2. Login with System Administrator user
  3. Right Click on instance name and select properties >> Advanced
  4. Change Max Degree of Parallelism to 1
  5. Restart the SQL Service
SharePoint 2013 - Max Degree Of Parallelism
SharePoint 2013 – Max Degree Of Parallelism

SharePoint 2013 -Max Degree Of Parallelsim

About The Author

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">

Close