How much memory is my SQL server using??
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