Find SQL Server Memory Grant OutStanding

-- Memory Grants Outstanding value for default instance

SELECT cntr_value AS [Memory Grants Outstanding]

FROM sys.dm_os_performance_counters WITH (NOLOCK)

WHERE [object_name] = N'SQLServer:Memory Manager' -- Modify this if you have named instances

AND counter_name = N'Memory Grants Outstanding' OPTION (RECOMPILE);

-- Memory Grants Outstanding above zero for a sustained period is a very strong indicator of memory pressure