Utilizing AWE

• dgermundson

  Hall of Fame

  Points: 3175

  More actions

  November 14, 2003 at 9:27 am

  #65736

  The last time we failed over our SQL server we got this in the logs:

  "Cannot use Address Windowing Extensions because lock memory privilege was not granted."

  We found that we needed to give access to the "lock pages in memory" user rights for the local security policy.

  The question is, if AWE Enabled is turned on and our server has 4GB of memory, how does it determine what memory to use when it hits this error? It's currently using about 2GB but how was that determined? The max memory setting is set to 4GB. Thanks.

  Darren

  
  Darren
  

• Jonathan

  SSC-Insane

  Points: 20427

  More actions

  November 14, 2003 at 10:10 am

  #482090

  Don't use AWE with only 4GB of memory in the server; use just /3GB. AWE is for managing memory above the 4GB boundary.

  --Jonathan

  Edited by - Jonathan on 11/14/2003 11:23:08 AM

  
  
  --Jonathan

• dgermundson

  Hall of Fame

  Points: 3175

  More actions

  November 14, 2003 at 11:12 am

  #482105

  So if we turn that off and reboot, it should access more than 2GB, correct?

  Darren

  
  Darren
  

• Jonathan

  SSC-Insane

  Points: 20427

  More actions

  November 14, 2003 at 11:22 am

  #482108

  quote:

  ---

  So if we turn that off and reboot, it should access more than 2GB, correct?

  Darren

  ---

  Set "awe enabled" to 0 and change the boot.ini if it has any memory switch other than just /3GB. I mistakenly typed "PAE" above when I meant "the 3GB extension."

  Also remove the "lock pages in memory" right from the startup user.

  --Jonathan

  
  
  --Jonathan