SQL server 2000- Maximum RAM support

  • Hi,

    What is the amount of total RAM supported by SQL server 2000 irrespective of any operating system compatible with it. Just please let me know, how much SQL 2000 can support. With my knowledge, I think it supports 2Gb maximum, by doing some os tweak, it can be boosted to 4Gb at most. Please clarify.

    Thanks in Advance!!!

  • Maximum memory supported by SQL 2000: http://msdn.microsoft.com/en-us/library/aa933149%28v=sql.80%29.aspx

    It is dependent on the operating system and SQL edition, ranging from 2 GB up to 64 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

Viewing 2 posts - 1 through 1 (of 1 total)

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