SQL 2016 brings us many new features but one of the most
anticipated is surely the Query Store. The Query Store now allows us to track
query plans as they change over time giving us a whole slew of new
possibilities when it comes to tuning our queries. Even just the ability to
compare a previous plan to a new plan is a huge step towards understanding what
may be happening in our instance. We can even tell the optimizer which plan we
want it to use. These were all either extremely difficult to do before and in
some cases impossible to do. This session will give you the insight to get
started using this new and wonderful feature set.
Presented by Andrew J. Kelly at SQLBits 2017