Abstract: In this full-day workshop, you will learn to leverage Query Store to quickly identify and solve query performance issues.
You’ll see 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. You’ll get tips for proper Query Store configuration and recommendations to reduce its impact on the production system.
Plan forcing is a very powerful feature, but a bit controversial. This workshop 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 force can bring additional troubles.
The next topic that will be covered 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.
Finally, you’ll learn how to mitigate Query Store limitations and common issues.
This workshop is a great opportunity to learn about Query Store or expand your knowledge and implement it successfully in your production system.
- Introduction to Query Store
- Configuring Query Store
- Query Store in Action
- Forcing Plans
- Automatic Tuning
- Issues and Limitations