Home Forums SQL Server 7,2000 Administration SQL 2000 memory recommendations RE: SQL 2000 memory recommendations

  • January 15, 2014 at 5:15 am

    #1680211

    Right, standard edition.

    Standard is hard-capped at 2GB of memory. It can't use more so the other 4GB of memory you have on that server is wasted. So the 1.6GB looks correct, the rest is the mem-to-leave section of memory (non-buffer memory)

    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