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.
Configure Resource Pools, Workload Groups, and Classifier Function, and then enable the Resource
Governor
B.
Set up Service Broker to ensure that application are not allowed to consume more than the specified
amount of resource
C.
Create a new rule for each application that sets the resource limit allowed
D.
Create a new plan Guide with a Scope Type of sql and define the resource limits for each application
Explanation:
In the SQL Server Resource Governor, a resource pool represents a subset of the physical resources of an
instance of the Database Engine. Resource Governor enables you to specify limits on the amount of CPU,
physical IO, and memory that incoming application requests can use within the resource pool. Each resourcepool can contain one or more workload groups. When a session is started, the Resource Governor classifier
assigns the session to a specific workload group, and the session must run using the resources assigned to the
workload group.
https://docs.microsoft.com/en-us/sql/relational-databases/resource-governor/resource-governorresource-pool