You need to optimize query executions

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?

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.
Move the master database to a RAID 10 volume.

B.
Move the SharePoint databases to a RAID 10 volume.

C.
Set the maximum degree of parallelism for SQL Server instances to 0.

D.
Move the master database to a RAID 5 volume.



Leave a Reply 0

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