How much memory sql server has with awe enabled

• mngong

  SSCertifiable

  Points: 6167

  More actions

  June 27, 2006 at 12:54 pm

  #172811

  Out of 20G of memory with awe enabled and /pae set sql server shows that it 218M is utilized and the processes show that 17G is reserved for sql server.

   

  What does the 218M represent since sql has 17G reserved and how can one find out if sql has used up say 4G of out of the 17G reserved..

   

  Thanks

• elliott cordo-298614

  SSC-Addicted

  Points: 453

  More actions

  June 27, 2006 at 1:24 pm

  #646194

  You should see all but 2GB .  To verify how much memory SQL sees and is using check Performance Monitor:

  SQLServer:Memory Manager\Total Server Memory

  SQLServer:Memory Manager\Target Server Memory

  Note that task manager will be very unreilable in showing you how much memory SQL Server is using.  Only rely on this counter.