Home Forums SQL Server 2008 SQL Server 2008 Administration Min and Max server memory RE: Min and Max server memory

  • April 17, 2013 at 11:54 pm

    #1607538

    prashanthreddymr (4/17/2013)

    I could see PAE is enabled in the boot.ini file as this is the 64 bit machine. Can you please suggest me removing of the PAE from boot.ini and adding /3gb is fine?

    If it's a 64-bit OS then /3GB is not needed (nor is /PAE), just set SQL's max server memory to 3 GB.

    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