Leveraging Query Store in Azure SQL Database
1 h 0 m
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):
- 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.
- Previous experience with SQL Server or Azure SQL Database
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.