Memory Grants Pending value

SELECT @@SERVERNAME AS [Server Name]
	,RTRIM([object_name]) AS [Object Name]
	,cntr_value AS [Memory Grants Pending]
FROM sys.dm_os_performance_counters WITH (NOLOCK)
WHERE [object_name] LIKE N'%Memory Manager%' -- Handles named instances
	AND counter_name = N'Memory Grants Pending'
OPTION (RECOMPILE);

dm_os_performance_counters

Get any memory dumps from SQL Server

Get Memory Clerk Usage

Get in-memory OLTP index usage

Check Memory pressure on the server