You are managing a SharePoint farm. The SharePoint databases are configured to run on a dedicated
instance of Microsoft SQL Server 2008 R2 Service Pack 1.You need to optimize query executions.
What should you do?
A.
Set the maximum degree of parallelism for SQL Server instances to 4.
B.
Set the maximum degree of parallelism for SQL Server instances to 1.
C.
Move the master database to a RAID 5 volume.
D.
Set the maximum degree of parallelism for SQL Server instances to 32.
Explanation:
Set max degree of parallelism (MAXDOP) to 1 for instances of SQL Server that host SharePoint databases
to make sure that a single SQL Server process serves each request.
Important:
Setting the max degree of parallelism to any other number can cause a less optimal query plan to be
used that will decrease SharePoint Server 2013 performance.
Ref: http://technet.microsoft.com/en-us/library/hh292622(v=office.15).aspx