Advanced Memory

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

Checks in this category

MEM006
OS-level memory pressure (process/system)
High
Detects a low-memory condition via stable boolean signals: process_physical_memory_low / process_virtual_memory_low (sys.dm_os_process_memory) for the SQL Server process, and system_low_memory_signal_state (sys.dm_os_sys_memory) for the OS. Uses the typed bit columns, never the localized description text.
Versions : 2012-2025
XTP002
XTP memory vs headroom
High
Compares memory consumed by memory-optimized tables to the server target memory.
Versions : 2014-2025
MEM001
Top Memory Clerks
Info
Identify top memory consumers
Versions : 2012-2025
MEM002
Buffer Pool by Database
Info
Buffer pool distribution per database (cached pages) — shows which databases occupy memory.
Versions : 2012-2025
MEM003
Memory Objects
Info
Top internal memory consumers (detailed memory objects / clerks) beyond the buffer pool.
Versions : 2012-2025
MEM004
Plan Cache by Type
Info
Plan cache distribution by object type (Adhoc, Prepared, Proc…) — reveals an ad hoc-polluted cache.
Versions : 2012-2025
MEM005
Adhoc Plan Cache Ratio
Info
Share of single-use ad hoc plans in cache — a high ratio wastes plan-cache memory.
Versions : 2012-2025
PLAN004
Plan-cache store pressure
Info
Captures the SQL Plans cachestore memory footprint (size and entry count).
Versions : 2012-2025