Session

Query Store Best Practices

Almost every time I present on the topic of Query Store, someone asks about the performance overhead of implementing it. It's not just about configuration options; there are aspects related to a system’s workload that are vital to understand and consider. In this session we will discuss the best practices for Query Store – not just the what, but also the why. We'll cover what you need to consider with SQL 2022 and how new Intelligent Query Processing features interact with Query Store. And finally, we'll talk about problematic workloads and what you can do to make Query Store an option for your solution. Whether you're running Azure SQL, or SQL Server 2016 or higher on-prem, it's worth taking the time to understand all the factors to optimize your use of Query Store.

Erin Stellato

Principal Program Manager at Microsoft

Cleveland, Ohio, 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