Leveraging Query Store in Azure SQL Database
Lab
Advanced
1 h 0 m
2017-09-19
Lab Overview
In this lab, you will leverage the Azure SQL Database Query Store to troubleshoot a plan regression issue. You will connect to the Query Store through SQL Server Management Studio, identify the plan regression, and then force the faster plan.

Related Learning Path(s):
Objectives
  • Monitoring consistency of query performance of Azure SQL Database.
  • Understanding query plan changes in Azure SQL Database.
  • Troubleshooting a query plan regression issue in Azure SQL Database using Query Store.
Pre-Requisites
  • Previous experience with SQL Server or Azure SQL Database
Exercises
In this exercise, you will manually deploy the environment needed for this lab.

In this exercise, you will take advantage of Query Store in Azure SQL Database to identify and correct a plan regression issue.

Real-Time Lab
Not Registered?
Create Account
Already Registered?
Login
What are Labs?

Labs provide a live environment to get hands-on experience using the same tools and services in the real world.


Learn More