Demystifying Query Store Plan Forcing
DBA, Database Developer
In this session, you will see Query Store in action and learn from many real-world examples, the author experienced with Query Store in the last four 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 the forced plan is respected, and when and why is not, and the most important – when you have to force a plan in the production system and when plan forcing can bring additional troubles.
We’ll also cover in detail is automatic tuning. You will understand the benefits and potential issues you can have with this feature and how to leverage it with no or minimal risk.
attendees should be familiar with Query Store basics