You have an Azure SQL managed instance named SQL1 and two Azure web apps named App1 and App2. You need to limit the number of IOPs that App2 queries generate on SQL1. Which two actions should you…

Question

Options

• AEnable query optimizer fixes.
• BEnable Resource Governor.
• CEnable parameter sniffing.
• DCreate a workload group.
• EConfigure In-memory OLTP.
• FRun the Database Engine Tuning Advisor.
• GReduce the Max Degree of Parallelism value.

• A
  3% (1)
• B
  79% (31)
• C
  3% (1)
• E
  5% (2)
• G
  10% (4)

Explanation

SQL Server Resource Governor is a feature that you can use to manage SQL Server workload and system resource consumption. Resource Governor enables you to specify limits on the amount of CPU, physical I/O, and memory that incoming application requests can use. The following concept is fundamental to understanding and using Resource Governor: * Workload groups. A workload group serves as a container for session requests that have similar classification criteria. A workload allows for aggregate monitoring of the sessions, and defines policies for the sessions. Each workload group is in a resource pool. Two workload groups (internal and default) are created and mapped to their corresponding resource pools when SQL Server is installed. Resource Governor also supports user-defined workload groups. https://docs.microsoft.com/en-us/sql/relational-databases/resource-governor/resource- governor?view=sql-server-ver15

No community discussion yet for this question.