Mastering SQL Query Performance: Sixty Minutes into the Query Store

Deepthi Goguri

Resolving the query performance problem quickly can be challenging. That’s where you can take advantage of the SQL Server feature known as Query Store. Query Store is a powerful feature in SQL Server that provides valuable insights into query performance and helps optimize database performance. The Query Store feature is so powerful that SQL Server 2022 enables all the new databases by default. Knowing how to leverage and take advantage of this feature to the fullest is also important.

In this demo-centric session covering SQL Server 2022 and Azure, you will learn-

* How Query Store collects the data
* Performance tuning with Query Store
* Automatic tuning
* Parameter Sensitive plan optimization
* Query hints
* Best practices in monitoring heavy workloads
* How to manage the Query Store
* Important tips to remember and things to avoid while using Query Store