Stabilizing Performance with Query Store
summary
Demo uses Wide World Importers to show plan forcing (manual jobs and automatic correction) and Query Store hints to stabilize a statement that flips between an index seek with key lookups and a clustered index scan; one value produces ~690 logical reads and ~841 ms, another yields ~55,000 reads after 26,000 row output, due to data skew. The workflow captures plans in Query Store, forces the good plan, and measures concrete IO and duration improvements without changing code.
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
22mA Beginners guide to Query Store
20mElevating SQL Server Performance with Query Store Hints
48mQuery Store: A Retrospective
53mBanishing Slow Queries with Intelligent Query Processing- 53mBanishing Slow Queries with Intelligent Query Processing
51mMaking the SQL Query Processor Work for you