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:
|
1 2 3 4 5 6 7 8 |
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; |
