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