Home Forums SQL Server 2012 SQL 2012 - General AWE on SQL SERVER 2012 and Windows Server 2008 Data Center? RE: AWE on SQL SERVER 2012 and Windows Server 2008 Data Center?

  • Don't mix up the AWE memory allocation API, which is used any time that locked pages is enabled, and the AWE setting which is only for 32 bit SQL.

    Yes, if you have locked pages enabled you will see that the memory is allocated using the AllocPhysicalPages API call rather than the VirtualAlloc, that's how locked pages work, pages allocated via AllocPhysicaPages can't be paged out by the OS.

    Set max server memory to a sensible value and you're fine.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass