I encountered a SQL server with multiple instances that was using a lot of memory. Some of the instances were not limited in their memory usage. I found a nice SQL query to lookup how much memory the instances were actually using.


SELECT (physical_memory_in_use_kb / 1024) AS CurrentlyUsedMemorybySQLServer
,(locked_page_allocations_kb / 1024) AS Locked_pages_used_Sqlserver_MB
,(total_virtual_address_space_kb / 1024) AS Total_VAS_in_MB
,process_physical_memory_low
,process_virtual_memory_low
FROM sys.dm_os_process_memory;