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.
SQL SERVER 2022 Features for Performance Optimization
I am sure by this time you all are aware that Microsoft has announced SQL Server 2022. It will be released sometime next year.
Auditing Query Hints Left in Production Code
Start auditing query hints in modules and Query Store, rank the busiest statements, and test removal with measured plans and rollback.
SQL SERVER – QDS_LOADDB Wait and Asynchronous Load of Query Store
The client who has SQL Server 2017 faced a very high wait type of QDS_LOADDB. The way to fix it is to enable the Asynchronous Load of Query Store.