October 11, 2011 at 12:38 am
I am interested in finding out how much memory SQL Server is exactly utilising?
But doesn't wanna use the Perfmon counters at all.
Mine SQL Server version is SQL Server 2008 R2 EE 64 bit.
October 11, 2011 at 2:03 am
sum(single_pages_kb+multi_pages_kb) as MemoryKB
group by name,type
order by memorykb desc
Hall of Fame
October 11, 2011 at 3:50 am
See my blog post.
MCTS SQL Server2k8
October 11, 2011 at 9:14 am
You can use DBCC MEMORYSTATUS
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply