SQL memory usage

• csales

  Ten Centuries

  Points: 1219

  More actions

  May 27, 2004 at 4:54 am

  #65966

  I've recently installed a new SQL server (Standard Ed) on Win2003.  Given that Std Edition is limited to 2 GB of memory I decided to put in 2.5GB to ensure that SQL will at least use the 2GB and have some spare for the OS.

  What I've found is the SQL processes are only using 1.7GB ram.  Now the databases on here are quite large and very query intensive so I would have assumed it would grab more memory (there are no limitation on the Max memory it can use).  I then tried setting the Minimum memory to 2GB but still it just uses 1.7GB?

   

  Any ideas?  Seems a waste to have memory not being used?

  thanks,

   

  Craig

   

• May 31, 2004 at 8:00 am

  This was removed by the editor as SPAM

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736140

  More actions

  May 31, 2004 at 9:19 am

  #508413

  I've had a number of 4GB machines and they never go above 1.7GB. It seems that the server algorithms that balance memory with the OS max out here.