This is one of the important DBA script to find details of Memory allocation and usage of the SQL Server.
During the performance tuning, it is very important to find a current allocation and other statistics about the SQL Server Memory.
There are different ways to find Memory details of the SQL Server.
In this post, I am using DBCC MEMORYSTATUS and sys.dm_os_process_memory DMV.
(physical_memory_in_use_kb/1024) AS Memory_usedby_SQLServer_in_MB
,(locked_page_allocations_kb/1024) AS Locked_pages_in_MB
,(total_virtual_address_space_kb/1024) AS Total_Virtual_Address_Space_in_MB