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.
Attendees will understand the role of different configuration options and what to select.
Attendees will understand the potential impact of different workloads on Query Store use.
Attendees will learn about new options in SQL Server 2019 for Query Store