Hi,

I tried setting the 3GB switch in the boot.ini on a system with W2K, and 4Gb of memory, running sql server 2000 standard edition. You appear to gain an extra gigabyte this way but I was not able to configure sql server to make use of the 'apparent' extra memory. This configuration is totally unsupported and way too risky on a production box.

2Gb is still alot of memory.

/marc



Marc David Martin
Database Administrator
Aarhus Amt
Environmental Agency, IT-Sekretariat
Lyseng Alle 1
8270 Hoejbjerg
Denmark

email: [Email Address Removed] (+ 45) 89 44 64 46

>>> "Maskevich, Tony" <Tony.[Email Address Removed] 08/28/03 07:58PM >>>

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]
For additional commands, e-mail: mssqldba-[Email Address Removed]


MS Sql Server LazyDBA home page