Session

Using Query Store to Understand and Control Query Performance

Understanding which queries are causing the most difficulty in your systems can be a challenge. Then, fixing those problematic queries is yet another challenge. The Query Store, running in SQL Server and Azure SQL Database, can help you identify problematic queries, and it can help you fix their performance. This session will show you the various data points that Query Store collects that will help you identify the queries that are behaving badly. In addition, this session will show you the different mechanisms within Query Store that can help you fix poorly performing queries. We'll cover Query Store functionality from SQL Server 2016 through to the new stuff in SQL Server 2022. Along the way we'll cover various settings that help you control how Query Store behaves. Query Store is something you can put to work immediately in your own environments that will help you improve performance right away.

Grant Fritchey

Redgate Software

Sapulpa, Oklahoma, United States

Actions

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top