Sql server and DEP RRS feed

  • Question

  • DEP is enabled on hardware level , (Explicit PAE  is not applied  on windows 2008 32 bit Enterprise ) ,To fucntion sql server 2008 r2 on the server do we need to do any configuration for DEP  in the sql server or OS?
    Thursday, July 26, 2012 7:23 PM


  • In DEP /PAE is got automatically enabled. Now you need :-

    If you are using more than 4GB of RAM

    • AWE needs to be configured in SQL Server so that SQL Server recognzies all the  RAM installed on the server
    • Set MIN & MAX memory for SQL server
    • Set lock page in memory rights

    Please click the Mark as Answer or Vote As Helpful if a post solves your problem or is helpful!

    Thursday, July 26, 2012 9:22 PM