Query Store Best Practices - Erin Stellato

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 also 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.
Watch the session recording from PASS Summit 2020. For updates on the future of PASS, SQLSaturdays and PASS Summit opt in here: www.red-gate.com/pass