link
Use the SQL Server Query Tuning Assistant
Understand the Query Store feature and how it continuously monitors the performance of your queries.
Microsoft Learn
Updated Jun 01, 2025
What you'll learn
- Decide if QTA is the right solution for them.
- Use the Query Store to assess query performance.
- Understand how QTA works to find regressing queries.
- Tune queries after migration to maintain performance
Course DescriptionThe Query Store feature introduced in SQL Server 2016 continuously monitors the performance of your queries. It caches query plans and gathers information that you can use to troubleshoot slow running queries. You can enable Query Store on any database on an instance of SQL Server 2016 or higher, including databases that have been migrated and continue to operate with an older compatibility level. The Query Tuning Assistant works alongside the Query Store. It uses the query performance statistics gathered when a database was migrated with its original compatibility level and compares them to the metrics gathered after the compatibility level is moved. By analyzing the differences, QTA finds queries that are regressing.
