Stored Procedures

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

Checks in this category

SP002
Top SP by Duration
Medium
Stored procedures consuming the most total elapsed time (sys.dm_exec_procedure_stats).
Versions : 2012-2025
SP003
SP Recompiles
Medium
Procedures with a high plan recompile count, indicating CPU pressure and plan instability.
Versions : 2012-2025
SP001
Top SP by CPU
Info
Stored procedures consuming the most CPU
Versions : 2012-2025
SP004
EXECUTE AS Procedures
Info
Procedures running under a different execution context (EXECUTE AS) — audit for privilege escalation.
Versions : 2012-2025