SQL server memory usage

• Helen-84411

  Hall of Fame

  Points: 3320

  More actions

  September 27, 2005 at 8:26 am

  #187827

  Hello all,

  How can I tell how much memory SQL Server is using on a server. On

  Windows 2000, whenever I go to Task manager/processes/memory usage SQL

  Server seems to be showing 2883104K(2.8 GB RAM). Avaibale is 738638 and System Cache is 836684. From this figure how can I calculate the memory used by DB server using commands like DBCC Memusage and DBCC MemoryStatus. Can someone explain this to me?

  

  
  Helen
  --------------------------------
  Are you a born again. He is Jehova Jirah unto me

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  September 28, 2005 at 8:20 am

  #593685

  have a look in sysperfinfo table - this will show memory being used.

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/