SQL Server 2000 can support up to 2GB only.

http://www.microsoft.com/sql/evaluation/overview/default.asp


John

-----Original Message-----
From: Maskevich, Tony [mailto:Tony.[Email Address Removed]
Sent: Thursday, August 28, 2003 11:59 AM
To: LazyDBA.com Discussion
Subject: SQL Server Memory > 2GB


I've been reading posts and MS sites, and see tons of info on the 3GB
Switch, AWE and PAE. I understand that Win2K Advanced or Data Center is
necessary to use > 2GB, but I haven't found any definitive statements on
SQL
edition.

If I have Win2K AE and SQL2K Standard, can I use the 3GB boot.ini
switch?
If so, I would imagine that I could use a 4GB server, with 3GB used by
SQL.
The 3GB switch does NOT use AWE, which requires SQL2K EE.

The reason I ask is that we have Win2K Server and SQL2K standard, and
we're
looking for the cheapest route to allow us to jump to 4GB. Win2K is a
relatively cheap upgrade, SQL is a VERY expensive one.


Tony




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page