Get any memory dumps from SQL Server

Get information on the location, time, and size of any memory dumps from SQL Server

SELECT [filename]
	,creation_time
	,size_in_bytes / 1048576.0 AS [Size (MB)]
FROM sys.dm_server_memory_dumps WITH (NOLOCK)
ORDER BY creation_time DESC
OPTION (RECOMPILE);

dm_server_memory_dumps

Get Memory Clerk Usage

Get in-memory OLTP index usage

Check Memory pressure on the server

Memory Grants Pending value

Resource Governor Resource Pool information