Home Forums SQL Server 2008 SQL Server 2008 - General Memory Utilised by SQL Server RE: Memory Utilised by SQL Server
cindyaz
Ten Centuries
Points: 1229
More actions
October 11, 2011 at 2:03 am
#1392699
select name,type,
sum(single_pages_kb+multi_pages_kb) as MemoryKB
from sys.dm_os_memory_clerks
group by name,type
order by memorykb desc