Get the best of the Query Store - Deepthi Goguri

WHEN:
Wednesday, November 8, 2023, 1700 GMT

DESCRIPTION of TALK

Title: Get the best of the Query Store

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.