You have an Azure SQL database. Users report that the executions of a stored procedure are slower than usual. You suspect that a regressed query is causing the performance issue. You need to view the

Question

Options

• APerformance Recommendations in the Azure portal
• BExtended Events in Microsoft SQL Server Management Studio (SSMS)
• CQuery Store in Microsoft SQL Server Management Studio (SSMS)
• DQuery Performance Insight in the Azure portal

• A
  3% (1)
• B
  19% (6)
• C
  72% (23)
• D
  6% (2)

Explanation

Use the Query Store Page in SQL Server Management Studio. Query performance regressions caused by execution plan changes can be non-trivial and time consuming to resolve. Since the Query Store retains multiple execution plans per query, it can enforce policies to direct the Query Processor to use a specific execution plan for a query. This is referred to as plan forcing. Plan forcing in Query Store is provided by using a mechanism similar to the USE PLAN query hint, but it does not require any change in user applications. Plan forcing can resolve a query performance regression caused by a plan change in a very short period of time. https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance- by-using-the-query-store

No community discussion yet for this question.