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 . 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

View Answer

Answer: A