memoria disponible en servidor SQL

 SELECT

(total_physical_memory_kb/1024) AS Total_OS_Memory_MB,

(available_physical_memory_kb/1024)  AS Available_OS_Memory_MB

FROM sys.dm_os_sys_memory;

SELECT  

(physical_memory_in_use_kb/1024) AS Memory_used_by_Sqlserver_MB,  

(locked_page_allocations_kb/1024) AS Locked_pages_used_by_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; 

select getdate() as fecha_y_Hora_Actual

salida.