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.
