select *,CAST(cntr_value/1024.0 as decimal(20,1)) MemoryMB
from master.sys.sysperfinfo
where counter_name='Total Server Memory (KB)'
2008+
SELECT physical_memory_in_use_kb/1024 AS physical_memory_in_use_MB,* FROM sys.dm_os_process_memory
参考MSDN:点击打开链接