What should you do?

You are the administrator of a Microsoft SQL Server 2012 server.

Some applications consume significant resources.

You need to manage the server workload by restricting resource-intensive applications. You need to dynamically limit resource consumption.

What should you do?
A . Set up Service Broker to ensure that applications are not allowed to consume more than the specified amount of resources.
B . Configure Resource Pools, Workload Groups, and Classifier Function, and then enable the Resource Governor.
C . Configure Extended Events to monitor and restrict resource limits allowed by each application type.
D . Create a new Plan Guide with a Scope Type of SQL and define the resource limits for each application.

View Answer

Answer: B

Explanation:

SQL Server Resource Governor is a feature than you can use to manage SQL Server workload and system resource consumption. Resource Governor enables you to specify limits on the amount of CPU, physical IO, and memory that incoming application requests can use.

The following three concepts are fundamental to understanding and using Resource Governor:

References: https://docs.microsoft.com/en-us/sql/relational-databases/resource­governor/resource-governor