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.
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!