SQL Server: Script to find Memory usage and allocation

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

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.

Using DBCC:

1	DBCC MEMORYSTATUS

Using sys.dm_os_process_memory:

SELECT

(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

,memory_utilization_percentage

,process_physical_memory_low

,process_virtual_memory_low

FROM sys.dm_os_process_memory;

Nov 3, 2016Anvesh Patel

Database Engineer