Post reply

Setting AWE, PAE, /3GB on SQL 2005?

  • November 13, 2006 at 2:27 pm

    #95008

    Hi - I have a two node cluster running Standard 2005 on Windows 2003 Entp edition. Has 8 GB of memory total. Is setting the AWE, PAE, and /3GB switches the same on SQL 2005 as for 2000? I haven't run into any info on it yet and was just curious.

    Thanks,

    -Mike

  • November 13, 2006 at 5:30 pm

    #671475

    PAE and /3GB are on windows level

    AWE is for SQL Server and its the same as SQL 2005.

     

  • November 14, 2006 at 2:39 am

    #671534

    If you are running 32-bit, everything is the same.  Just as in SQL2000, the only aspect of SQL2005 that can take advantage of AWE memory is the database buffer pool.

    If you are running 64-bit you do not need any of these items.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply