- Course
Effective Query Analysis with SQL Server Tools
Once a database is converted to SQL Server 2022, how do you find regressed queries? Learn to interpret the results of the Query Tuning Assistant with the Query Store for database queries that regress between versions of SQL Server.
Beginner
- Course
Effective Query Analysis with SQL Server Tools
Once a database is converted to SQL Server 2022, how do you find regressed queries? Learn to interpret the results of the Query Tuning Assistant with the Query Store for database queries that regress between versions of SQL Server.
Beginner
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
What you'll learn
The Query Store contains the execution plans to improve performance or show regressed plans, while the Query Tuning Assistant helps with its analysis of the convert database.
In this course, Effective Query Analysis with SQL Server Query Tuning Assistant, you’ll gain the ability to execute the Query Tuning Assistant to analyze queries captured in the Query Store.
First, you’ll explore the Query Store and metric data related to captured SQL statements.
Next, you’ll discover the results of the Query Tuning Assistant and how to differentiate resources from T-SQL issues.
Finally, you’ll learn how to develop a plan to improve the performance of a database from the results of the Query Tuning Assistant.
When you’re finished with this course, you’ll have the skills and knowledge of the Query Tuning Assistant needed to read metric data from the Query Store to performance-tune a set of database queries.
Effective Query Analysis with SQL Server Tools
Beginner
Table of contents
Microsoft Data Platform MVP specializing in SQL Server, Microsoft Business Intelligence (SSIS, SSAS & SSRS) and Power BI.