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.
