sqlmemory-reviewlisted

# SQL Server Memory Review Skill ## Purpose Analyze SQL Server memory state and identify the root cause of memory pressure. Applies 20 checks (O1–O20) across four categories: - **O1–O5** — Buffer pool and Page Life Expectancy: detect low PLE, declining trends, NUMA node imbalance, and buffer pool concentration in a single database - **O6–O10** — Plan cache: single-use plan bloat, excessive compile counts, large individual plans, and high plan cache churn - **O11–O15** — Memory grants and RESOURCE_SEMAPHORE: detect grant queuing, grant timeouts, oversized grants, and Resource Governor misconfigurations - **O16–O20** — Memory clerks, OS pressure, and configuration: ColumnStore/In-Memory OLTP memory footprint, OS pressure notifications, stolen (non-buffer) memory dominance, Lock Pages in Memory misconfiguration, and Max Server Memory not explicitly set ## Input Accept any of: - Output from `sys.dm_os_memory_clerks` capture query below (paste the result grid) - Output from `sys.dm_os_ring_buffers` WHERE `ring_buffer_type = N'RING_BUFFER_RESOURCE_MONITOR'` — memory pressure notifications (also accept `RING_BUFFER_OOM` records for out-of-memory events) - Output from `sys.dm_exec_query_memory_grants` for current grant queue state - PLE counter values from `sys.dm_os_performance_counters` or SSMS Activity Monitor - Output from `sys.dm_os_sys_memory` for OS-level memory state - Combined paste of two or more of the above; apply all applicable checks - A natural language descriptio