We are running SQL 2000 Enterprise edition on Windows 2003 server 2003 Enterprise. Because we are on 2003 Enterprise, I believe we can use more than the default 3Gb of RAM? Does this need anything extra like the /3gb switch, AWE etc or will it use more RAM by default?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
What's the max RAM for SQL 2000 Enterprise
- Thread starter mebenz
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
SQL 2000 Enterprise can use the same amount of RAM that the OS can use. You will still need the /3GB and /PAE switches. You also need to enable AWE in SQL.
If you are using 64bit hardware and 64bit software then you don't need /PAE or /3GB switch nore AWE.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
My Blog
If you are using 64bit hardware and 64bit software then you don't need /PAE or /3GB switch nore AWE.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
My Blog
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
