Session Details

View all Conference Sessions

Demystifying Query Store Plan Forcing

75 minutes
Data Management
DBA, Database Developer
Database Administration
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