Using Query Store in SQL Server to Detect Plan Regressions
Query Store lets you capture every query’s plan and runtime stats in SQL Server, giving a durable baseline for performance tuning and regression detection. Enable it once, tune retention, and use plan_compare to spot regressions in production.