Top Queries

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

Checks in this category

QRY003
Top Duration Queries
Medium
Queries with the longest execution duration
Versions : 2012-2025
QRY007
Top Memory Grant Query
Medium
Query requesting the largest memory grant — risk of RESOURCE_SEMAPHORE waits and tempdb spills.
Versions : 2012-2025
QRY001
Top CPU Queries
Info
Queries consuming the most CPU
Versions : 2012-2025
QRY002
Top I/O Queries
Info
Queries with the most logical reads
Versions : 2012-2025
QRY004
Top Writes Query
Info
Query generating the most logical writes (sys.dm_exec_query_stats), an I/O optimization candidate.
Versions : 2012-2025
QRY005
Most Frequent Query
Info
Most executed query (execution_count) — optimizing it yields the highest cumulative impact.
Versions : 2012-2025
QRY006
Implicit Conversions in Plans
Info
Plans containing implicit conversions (CONVERT_IMPLICIT) that prevent index seeks and skew estimates.
Versions : 2012-2025