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