Answer
Query Store provides:
- Plan history recording
- Runtime performance metrics
- Ability to revert to stable plans
- Insight into parameter sniffing behavior
It acts as a "black box recorder" for SQL Server.
Quick Answer
Query Store tracks every query's execution history — plan, duration, CPU, I/O, logical reads. In high-traffic systems it enables: detecting plan regressions instantly, forcing known-good plans, identifying top resource consumers, and understanding query behavior over time without relying on memory-only DMVs that reset on restart.
S
SugharaIQ Editorial Team
Verified Answer
This answer has been peer-reviewed by industry experts holding senior engineering roles to ensure technical accuracy and relevance for modern interview standards.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ