PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

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