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

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?

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.



Leave a Reply 7

Your email address will not be published. Required fields are marked *


Mrs.DBA

Mrs.DBA

Agree. But why all the brain dump has Service broker as answer?

noname

noname

Cause they all copy each other lol

MKL

MKL

Ans. is B. Configure Resource Pools, Workload Groups………

Islam

Islam

I think so too