Memory Utilised by SQL Server

• Jeetendra

  SSCrazy

  Points: 2076

  More actions

  October 11, 2011 at 12:38 am

  #249656

  Hi All,

  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.

  ---

  Kindest Regards,

  Jeetendra
  

• 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

• Ali Tailor

  Hall of Fame

  Points: 3769

  More actions

  October 11, 2011 at 3:50 am

  #1392737

  Hi;

  See my blog post.

  http://mumbaisqldba.wordpress.com/2011/10/11/finding-out-how-much-memory-sql-server-is-utilizing/%5B/url%5D

  Ali
  MCTS SQL Server2k8

• chris.mcgowan

  SSCarpal Tunnel

  Points: 4269

  More actions

  October 11, 2011 at 9:14 am

  #1392937

  You can use DBCC MEMORYSTATUS

  http://support.microsoft.com/kb/907877

  Thanks

  Chris

  ------------------------
  I am the master of my fate:
  I am the captain of my soul.
  ------------------------
  Blog: http://sqlserver365.blogspot.co.uk/
  Twitter: @ckwmcgowan
  ------------------------