[sql] view plain copy print ? select *,CAST(cntr_value/1024.0 as decimal(20,1)) MemoryMB from master.sys.sysperfinfo where counter_name='Total Server Memory (KB)' 2008+ [sql] view plain copy print ? SELECT physical_memory_in_use_kb/1024 AS physical_memory_in_use_MB,* FROM sys.dm_os_process_memory