Query Store

The 8 checks in the “Query Store” category of a SQL Server audit: what each one verifies, its severity and the versions covered.

Checks in this category

QS001
Query Store Enabled
High
Checks if Query Store is enabled on each user database
Versions : 2016-2025
QS002
Query Store READ_ONLY
High
Detects if Query Store has switched to READ_ONLY mode due to insufficient space
Versions : 2016-2025
QS003
Query Store Size Usage
Medium
Checks the percentage of Query Store allocated space being used
Versions : 2016-2025
QS006
Stale/Failed Forced Plans
Medium
Detects stale or failed forced plans that are no longer effective
Versions : 2016-2025
QS004
Query Store Capture Mode
Low
Checks the Query Store capture mode (ALL, AUTO, CUSTOM, NONE)
Versions : 2016-2025
QS005
Forced Plans
Info
Identifies forced execution plans in Query Store
Versions : 2016-2025
QS007
QS Wait Stats Capture
Info
Checks if wait statistics capture is enabled in Query Store (SQL 2017+)
Versions : 2017-2025
QS008
Recent QS Activity
Info
Checks if Query Store is actively collecting recent data
Versions : 2016-2025