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.
(Visited 44 times, 1 visits today)
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
(Visited 1 times, 1 visits today)
