What should you do?

You are the administrator of a Microsoft SQL Server 2016 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