Memory Problem

• NelsonVere

  Ten Centuries

  Points: 1280

  More actions

  September 26, 2003 at 8:36 am

  #82602

  I have before 512K and we add another 512K

  so we ave now 1GB memory and sql server is using 900mb of that, we add more memory go to 1.8GB and sqlserver is using 1.7 GB ..

  How I fix that? why sqlserver is using all the memory on the server?

  any ideas?

  thanks

  Nelson

• Jonathan

  SSC-Insane

  Points: 20427

  More actions

  September 26, 2003 at 8:45 am

  #476027

  quote:

  ---

  why sqlserver is using all the memory on the server?

  ---

  Because that is what it is designed to do. No problem.

  --Jonathan

  
  
  --Jonathan

• Larry C

  SSCommitted

  Points: 1543

  More actions

  September 26, 2003 at 12:56 pm

  #476071

  To run effeciently, SQL uses as much memory as possible for cacheing, etc. SQL is designed to give back memory as other apps need memory.