title: Can someone explain my Windows/SQL Server memory usage
body: <p>I'm running Windows Server 2003 x64 with 8GB RAM and SQL Server 2005 64 bit. I have SQL set to use loads of memory, but the SQL process only ever takes under 100 MB RAM. Is this normal? It is accessing data with indexes many GBs in size.</p>
  
  <p>Moreover, no process is taking over 100MB, yet there is only a minimal (&lt;100MB) amount ofree memory. </p>
  
  <p>Could some kind person explain to me where the memory is being used and if the SQL memory usage is normal?</p>
  
  <p>Memory usage:
  <a href="http://img129.imageshack.us/img129/8624/02042009210608.png" rel="nofollow noreferrer">http://img129.imageshack.us/img129/8624/02042009210608.png</a></p>
  
  <p>SQL Server memory settings:</p>
  
  <p><a href="http://img10.imageshack.us/img10/8964/02042009210845.png" rel="nofollow noreferrer">http://img10.imageshack.us/img10/8964/02042009210845.png</a></p>
  
  <p>Memory details:</p>
  
  <p><a href="http://img228.imageshack.us/img228/3830/02042009210917.png" rel="nofollow noreferrer">http://img228.imageshack.us/img228/3830/02042009210917.png</a></p>