PASS logo

Summit video library

Mastering Query Store: Best Practices for Performance Tuning

Deepthi Goguri

Query optimization is an important part of a Database Administrator job. Query store feature is used to identify and fix the query performance issues.

In this Demo-centric presentation, we will take a deep dive into mastering the Query Store feature and its latest enhancements in SQL Server 2022 and in Azure SQL database. This session will cover the advantages of Query Store, Automatic plan correction in SQL Server and in Azure SQL database, Query hints with real time scenarios and examples.

Attendees will leave this presentation with a solid understanding of Query Store and how to use it to optimize query performance in both SQL Server 2022 and Azure. They will also learn best practices for using Query Store to identify and troubleshoot performance issues, and how to leverage this feature for maximum Query performance.

Get the Latest

Sign up to stay up to date with news, special announcements and educational content.

Redgate will only contact you about PASS Data Community Summit (in line with our Privacy Policy) unless you separately request emails about Redgate. You can unsubscribe from these updates at any time.