Memory usage

• John Deupree

  SSCommitted

  Points: 1705

  More actions

  June 4, 2003 at 3:44 pm

  #105865

  When monitoring our server (SQL2000) I notice that after a reboot (once a week), memory usage starts out about 10% (of 2gb) and over a day or so climbs to 80% and stays there until the next reboot. Is this normal? Should SQL release memory when it is no longer needed?

  TIA

  John

  John Deupree

• lansley

  Ten Centuries

  Points: 1055

  More actions

  June 4, 2003 at 8:58 pm

  #459846

  This is a common point of confusion. SQL Server only releases memory on reboots and when the operating systems requests memory. As long as the OS is satisfied, SQL Server will retain memory.

  Larry Ansley

  
  Larry Ansley
  Atlanta, GA