How to Find out How Much Memory is Allocated to SQL Server Instance - SQL Server DBA Tutorial

In this video you will learn how to find how much memory is allocated to SQL Server instances using various methods. Methods include by viewing SQL Server memory configuration via SSMS, using SQL Server dynamics system view and how to configure SQL Server Minimum (min) and Maximum (Max) memory using SQL Server Memory Configuration.

Memory Allocated to SQL Server Instance

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;

How to Find out How Much Memory is Allocated to SQL Server Instance - DBA Tutorial