Stabilizing Performance with Query Store
summary
Demonstrates using plan forcing and Query Store hints to stabilize a procedure that shows plan sensitivity: the same proc returns 26,000 rows for customer 401 and 2 rows for others, producing ~55,000 logical reads and slow durations versus ~690 reads and ~100 ms for the cheap case. Uses WideWorldImporters for demos, shows Query Store storing up to 200 plans by default, and shows manual forcing, automatic plan correction, and a cache-refresh job as temporary fixes without changing schema.
AI-written summary · about
chapters (5)
- 0:00Introduction and roadmap
- 2:22Challenges in query planning
- 6:27Performance troubleshooting
- 9:48Demonstration setup and analysis
- 15:30Using Query Store insights
related talks
19mStabilizing Performance with Query Store- 19mStabilizing Performance with Query Store
20mElevating SQL Server Performance with Query Store Hints- 20mElevating SQL Server Performance with Query Store Hints
22mA Beginners guide to Query Store
53mBanishing Slow Queries with Intelligent Query Processing- 22mA Beginners guide to Query Store
51mMaking the SQL Query Processor Work for you