Here's a query I use. I just picks up the Windows perf counter values around SQL Server.

select counter_name, cntr_value / 1024.0 / 1024.0 as GB, *

from master..sysperfinfo

where object_name = 'SQLServer:Memory...