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.
Leave a Reply