In this session, you will see Query Store in action and learn from many real-world examples, the author experienced in the last three years in the complex SQL Server production environment with heavy workloads.

Plan forcing is a very powerful feature, but a bit controversial. This session will demystify it; you’ll see what Query Store exactly does when an execution plan is forced when it is respected, when and why isn’t, and the most important – when you have to force a plan in the production system, and when forcing can bring additional troubles.

We’ll also cover in detail is automatic tuning. You will understand benefits and potential issues you can have with this feature and how to leverage it with no or minimal risk.