A Beginners guide to Query Store
summary
Query Store captures execution plans, estimated plans, runtime stats and wait statistics, storing them per database so you can find plan regressions and top resource consumers. Enable with ALTER DATABASE ... SET QUERY_STORE = ON and set OPERATION_MODE = READ_WRITE; it captures SELECT and DML but not DDL/DCL. Defaults push in-memory samples to disk every 90s and roll up captures hourly (can be reduced to minutes at higher storage cost). It also supports forcing specific plans and comparing join algorithms.
AI-written summary · about
chapters (7)
- 0:00Introduction
- 2:38Query store overview
- 6:27Plan cache vs query store
- 10:00Plan types and data capture
- 12:57Forcing plans and stats
- 17:20Troubleshooting with weights
- 20:06Conclusion and resources
related talks
22mA Beginners guide to Query Store
48mQuery Store: A Retrospective
26mUsing Azure Query Store to Understand PostgreSQL Performance
20mElevating SQL Server Performance with Query Store Hints
19mStabilizing Performance with Query Store
50mQuery Store Best Practices- 19mStabilizing Performance with Query Store
49mPerformance Features in SQL Server and Azure SQL