SQL Server Standard Edition can use up to 2GB of RAM. You must use
Enterprise Edition of SQL Server to use more than 2GB. As far as the OS
goes, I believe that you can use Windows 2000 Server (standard) for
installations up to 4GB, Advanced Server for 4-8GB, and Data Center 8-64GB.


Kevin Martin
Database Engineer
Multimedia Games, Inc.




-----Original Message-----
From: Maskevich, Tony [mailto:Tony.[Email Address Removed] Thursday, August 28, 2003 1:59 PM
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] mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 8/19/2003


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 8/19/2003

MS Sql Server LazyDBA home page