Kalen Delaney has been working with SQL Server for over 32 years, providing advanced SQL Server training to clients around the world. She SQL Server MVP for 25 years before joining Microsoft where she writes and delivers SQL Server training.
Behind the Query Store…
Look inside Query Store to see what it does and how it works
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.