Monday, April 16, 2012

Good basic information about memory amounts and state

-- Good basic information about memory amounts and state
-- SQL Server 2008 and 2008 R2 only
SELECT total_physical_memory_kb ,
available_physical_memory_kb ,
total_page_file_kb ,
available_page_file_kb ,
system_memory_state_desc
FROM sys.dm_os_sys_memory ;

No comments:

Post a Comment