SQL Server 2000 RAM limitations on windows 2000 server

• Thomas Woods

  SSC Enthusiast

  Points: 130

  More actions

  January 14, 2004 at 1:28 pm

  #101842

  Is SQL server 2000 really limited to 2GB RAM on a windows 2000 server

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  January 14, 2004 at 1:54 pm

  #490066

  This depends on the version of SQL Server you have. Standard edition is limited, Enterprise edition not. Take a look at Maximum capacity specifications in BOL for detailed informations.

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  January 15, 2004 at 1:19 am

  #490149

  Please avoid double postings. See Allen Cui's answer here

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=95240

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]