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 1:05 am

    #1547484

    If you have 16 GB of memory, you do not want the /3GB switch enabled, it can be harmful. I suggest you remove that switch. You just need the /PAE and AWE enabled within SQL Server.

    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