Post reply

Memory configuration

  • April 2, 2014 at 10:34 pm

    #287189

    Hi,

    What is the max memory support for SQL server 2000(32 bit)

    when i came across technet i got this information

    Operating System Enterprise EditionStandard EditionPersonal EditionDeveloper Edition"Desktop Engine

    (MSDE 2000)"

    Windows 2000 DataCenter64 GB 2 GB 2 GB 64 GB 2 GB

    SQL Server CEEnterprise Evaluation Edition

    N/A 64 GB

    http://technet.microsoft.com/en-us/library/aa933149(v=sql.80).aspx

    If i use operating system as Windows NT 4.0 Server RAM is limited to 2 GB ?

    so if my operating system is Windows 2000 DataCenter (32) bit can i use 64 GB of RAM?

    Any suggestions on this.

  • April 3, 2014 at 1:02 am

    #1702744

    The documentation is correct (unsurprising)

    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

  • April 3, 2014 at 3:58 am

    #1702784

    Thanks Gail for replaying in this SQL 2000 forum.

    So if i am using Windows 2000 DataCenter as 32 bit OS , can it take 64 GB of RAM.

  • April 3, 2014 at 10:08 am

    #1702942

    If that's what the documentation says, then that's what it can take.

    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

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

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