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 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.
You are managing a SharePoint farm. The SharePoint databases are configured to run on a dedicated instance of Microsoft
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
You are managing a SharePoint farm. The SharePoint databases are configured to run on a dedicated instance of Microsoft
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!