Use the SQL Server Query Tuning Assistant
Learn how the Query Tuning Assistant (QTA) works alongside the Query Store to compare query performance statistics and find queries that are regressing due to changing compatibility levels.
Learning objectives
In this module, you:
- Evaluate query tuning solutions like the QTA and automatic plan correction.
- Learn how to use the Query Store to assess query performance.
- Understand how the QTA works to address regressing queries.
- Learn how to use the QTA to maintain query performance after database upgrade.
Prerequisites
- Knowledge of SQL Server database properties and options
- Experience with using SQL Server Management Studio (SSMS) or executing SQL queries
- Understanding of query plans, query tuning, and performance optimization