SQL Server 2016 Introduced an incredible monitoring and tuning technology called Query Store that provides us with insight into the optimizer’s plan choices and the history of changes in plans. Query Store allows you to revert to a previous better performing plan through the use of Plan Guides. In this session, we’ll see what kinds of query performance problems can be solved with Query Store and what kinds can’t be. We’ll look at how Query Store evaluates query performance information and how we can revert to an old plan. Finally, we’ll see a new SQL Server 2017 technology called Automatic Plan Correction that is built on top of Query Store.
Presented by Kalen Delaney at SQLBits 2019