I was recently asked this question. Would like to know some opininon on what is the best strategy.
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 SharePoint databases to a RAID 10 volume.
B. Move the SharePoint databases to a RAID 5 volume.
C. Set the maximum degree of parallelism for SQL Server instances to 4.
D. Set the maximum degree of parallelism for SQL Server instances to 0.