SQL Server 2022 extends the Query Store feature for secondary replicas. Here is how to enable it and what to watch before using it.
SQL Server 2022 – Cardinality Estimation (CE) Feedback for Performance
SQL Server 2022introduces an enhanced Cardinality Estimation (CE) feedback feature as part of the intelligent query processing family.
SQL Server 2022 – Degree of Parallelism (DOP) Feedback for Optimize Query Performance
SQL Server 2022 introduces a powerful new feature called Degree of Parallelism (DOP) feedback as part of the Intelligent Query Processing (IQP).
Query Store Wait Stats: Why a Query Was Slow, Not Just That It Was
Read Query Store wait stats by query, plan, interval, and category, then compare matched windows with execution counts and capture coverage.
Query Store Interval Length: Choosing How Fine Your History Is
An hourly average can hide the slowdown users remember. Here is a small demo of Query Store interval length and how to choose it.
tempdb-Heavy Queries: Finding Them in Query Store
The tempdb spike is over before you log in. Query Store remembers who caused it, and here is how to ask.
Last Used Stored Procedure in SQL Server: When Did It Last Run?
To find the last used stored procedure, read last_execution_time from sys.dm_exec_procedure_stats. This post tests it on demo procedures, shows why a NULL does not mean never, and adds Query Store for a longer memory.