Current Memory Use By SQL Server
See where SQL Server's memory is going. I believe this is a slightly modified version that I originally got from Slava's Blog. I have found it to be invaluable since SQL Server 2005 was released.
select type, sum(virtual_memory_reserved_kb) as [VM Reserved], sum(virtual_memory_committed_kb) as [VM Committed], sum(awe_allocated_kb) as [AWE Allocated], sum(shared_memory_reserved_kb) as [SM Reserved], sum(shared_memory_committed_kb) as [SM Committed], sum(multi_pages_kb) as [MultiPage Allocator], sum(single_pages_kb) as [SinlgePage Allocator] from sys.dm_os_memory_clerks group by type order by 8 desc
Query Test Checklist
Tests Updated by Brent Ozar, 2009-04-01