You are the administrator of a Microsoft SQL Server database server. Some applications consume significant resources. Yo

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899604
Joined: Mon Aug 02, 2021 8:13 am

You are the administrator of a Microsoft SQL Server database server. Some applications consume significant resources. Yo

Post by answerhappygod »

You are the administrator of a Microsoft SQL Server database 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. Create a new Plan Guide with a Scope Type of sql and define the resource limits for each application.
B. Enable the Resource Governor, and then configure Resource Pools, Workload Groups, and Classifier Function.
C. Configure SQL Activity Monitor to define resource limits for each application type.
D. Configure Extended Events to monitor and restrict resource limits allowed by each application type.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This topic has 1 reply

You must be a registered member and logged in to view the replies in this topic.


Register Login
 
Post Reply