罠①: メモリ grant 不足の検知 (DMV クエリ)

-- Resource Semaphore のキュー俯瞰
SELECT
    resource_semaphore_id,
    target_memory_kb     / 1024 AS target_mb,
    max_target_memory_kb / 1024 AS max_target_mb,
    total_memory_kb      / 1024 AS total_mb,
    available_memory_kb  / 1024 AS available_mb,
    granted_memory_kb    / 1024 AS granted_mb,
    used_memory_kb       / 1024 AS used_mb,
    grantee_count,
    waiter_count,
    forced_grant_count
FROM sys.dm_exec_query_resource_semaphores;