While installing SharePoint 2013 we set max degree of parallelism in SQL server to 1. Is there any reason for this configuration? And why is it necessary to set it to 1.
Couple of videos on channel9 SharePoint conference 2014 about SQL tuning for Optimizing SQL Server 2012 for SharePoint 2013 by Brian Alderman and Advanced Performance Analysis for SharePoint by Ryan Campbell.
A TechNet q&a and MSDN blog Roger Cormier Configure MAXDOP
Mike B
MAXDOP is a setting that defines how many CPUs SQL Server uses when it’s executing a query. That’s great, if the queries were written to take advantage of that setting. If they weren’t, splitting the execution among multiple processors can have unpredictable results.
This link will take you to more information and how to optimize SQL Server for SP2013
Regards,
Bismarck
Suggested reasons in Todd Klindt blog at: http://sharepointpromag.com/sql-server-2012/configure-sql-server-2012-sharepoint-2013
Mike B
