PdfPrep.com

What should you do?

You are deploying a Microsoft SQL Server database that will support a mixed OLTP and OLAP workload. The target virtual machine has four CPUs.

You need to ensure that reports do not use all available system resources.

What should you do?
A . Enable Auto Close.
B . Increase the value for the Minimum System Memory setting.
C . Set MAXDOP to half the number of CPUs available.
D . Increase the value for the Minimum Memory per query setting.

Answer: C

Explanation:

When an instance of SQL Server runs on a computer that has more than one microprocessor or CPU, it detects the best degree of parallelism, that is, the number of processors employed to run a single statement, for each parallel plan execution. You can use the max degree of parallelism option to limit the number of processors to use in parallel plan execution.

Exit mobile version