Designing Database Solutions for Microsoft SQL Server — Question 13

You have a server named Server1 that has 2 processors.
You plan to deploy multiple instances of SQL Server 2014 to Server1. Each instance will have multiple databases.
You need to recommend a method to set limits on processor time for each database.
What should you include in the recommendation?
More than one answer choice may achieve the goal. Select the BEST answer.

Answer options

• A. processor affinity
• B. Max Degree of Parallelism
• C. Windows System Resource Manager (WSRM)
• D. Resource Governor

Correct answer: D

Explanation

The correct answer is D, Resource Governor, as it allows you to manage SQL Server workload and resource consumption by setting limits on CPU and memory usage for different workloads. Options A and B do not directly limit processor time per database, while C, Windows System Resource Manager, is more focused on managing resources at the Windows level rather than specifically for SQL Server databases.