QuestionQ86

VerifiedMonitor, configure, and optimize database resources

You have an Azure SQL Managed Instance named SQL1 and two Azure web apps, App1 and App2.

You need to restrict the number of IOPS generated on SQL1 by queries from App2.

Which two actions should you take on SQL1? Each correct answer is part of the solution.

NOTE: Each correct selection is worth one point.

Choose two
Explanation

Resource Governor can enforce limits on physical I/O used by user query workloads in Azure SQL Managed Instance. A workload group provides the separate, classifiable set of App2 sessions to which the resource-governance policy is applied.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!