SQL server 2000- Maximum RAM support

• vijayakumarn

  SSChasing Mays

  Points: 615

  More actions

  April 18, 2013 at 1:49 am

  #104195

  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!!!

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  April 18, 2013 at 2:01 am

  #1607568

  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