sys.dm_os_sys_memory

SELECT * FROM sys.dm_os_sys_memory

Returns a complete picture of memory at the operating system level, including information about total and available physical memory, total and available page memory, system cache, kernel space and so forth.

http://msdn.microsoft.com/en-us/library/bb510493.aspx