Home Forums SQL Server 2005 SQL Server 2005 General Discussion How to Set Minimum and Maximum memory in AWE SQL2005 RE: How to Set Minimum and Maximum memory in AWE SQL2005

  • October 10, 2012 at 2:22 am

    #1547515

    Again, you do not need /3gb for memory usage above 4GB. That's the /PAE switch and the AWE settings alone. With 16 GB memory, /3GB can be harmful as it reduces the number of page table entries you have and can result in memory issues for the OS.

    Chapter 4: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    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