SQL 2005 Memory Occupation

• durai nagarajan

  SSCoach

  Points: 15778

  More actions

  April 16, 2010 at 10:54 am

  #144114

  I have noticed sql server has taken around 50% RAM size memory and keep with it even when the server is not having much load.

  Is it a way to release it or findout which of sql background process occupying the memory size.

  Thanks in advance.

  Regards
  Durai Nagarajan

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  April 16, 2010 at 1:01 pm

  #1153083

  It will release it only if required(for example, OS starving for memory --Experts plz comment).

  To monitor memory usage use DBCC Memorystatus(http://support.microsoft.com/kb/271624).

  Also, DMV named 'sys.dm_os_memory_clerks' could be used too.

  MJ