Exercise: Optimize query performance
In this exercise, you investigate slow queries in Azure SQL Database using execution plans, dynamic management views (DMVs), and Query Store. You identify a missing index through the execution plan, simulate a parameter sniffing regression with a stored procedure, use the Query Store GUI to detect and fix the regression, apply a Query Store hint, and diagnose a blocking scenario.
Note
To complete this exercise, you need an Azure subscription.
Launch the exercise and follow the instructions.
