Very Computer

OS: Win 2K Advanced Server
DB: SQL2k Enterprise
Hardware: Compaq 8500; 8G RAM

Problem: The OS recognizes all 8G of RAM; however, SQL does not...If I set SQL to use a fixed amount of RAM (7.5G), upon starting the service, it writes an error to the event log that it is unable to allocate that much RAM (It also writes to the event log that 2048M of RAM was detected).  I can allocate RAM, provided RAM allocated <= 2048M.

I hope someone has run into an issue like this in the past and can provide assistance.

Thanks

-Greg

SQL Server 200 Processer and RAM Support (Enterprise Edition)

No of Processors            Amount of RAM Supported

1 - 4                                1 - 2 GB

4 - 10                              8 GB

10 - 20                            16 GB

20 - 64                            32 GB

If everything as above stated is fine then post the Error Message that you
have in the event Log.

HTH
Saleem Hakani

Quote:----- Original Message -----
From: Gregory A. Ferdinandsen

Newsgroups: microsoft.public.sqlserver.server
Sent: Wednesday, November 29, 2000 9:39 PM
Subject: RAM Problem

OS: Win 2K Advanced Server
DB: SQL2k Enterprise
Hardware: Compaq 8500; 8G RAM

Problem: The OS recognizes all 8G of RAM; however, SQL does not...If I set
SQL to use a fixed amount of RAM (7.5G), upon starting the service, it
writes an error to the event log that it is unable to allocate that much RAM
(It also writes to the event log that 2048M of RAM was detected).  I can
allocate RAM, provided RAM allocated <= 2048M.

I hope someone has run into an issue like this in the past and can provide
assistance.

Thanks

-Greg

WindowsNT/2k allocates a working set of 2GIG of memory for itself when
running.   So if you have a machine with 8gig of memory on it, Windows is
going to take 2GIG of that memory for itself.  That may be why SQL Server
doesn't like you setting of 7.5gig.  There is a switch in Enterprise and it
appears to still be in Win2K which is known as 4GT tuning or they call it
now Address Windowing Extensions API.

Now the switch is /3GB placed in the boot.ini file, but that was designed
with the max was 4gig of memory.  I'm not sure if you need to change that or
if there is a different switch for machines with 8gig of memory.  you may
want to contact Microsoft or your VAR and have them contact Microsoft.

That's assuming you really want SQL server to get at up to 7 gig of your
8gig of memory.


OS: Win 2K Advanced Server
DB: SQL2k Enterprise
Hardware: Compaq 8500; 8G RAM

Problem: The OS recognizes all 8G of RAM; however, SQL does not...If I set
SQL to use a fixed amount of RAM (7.5G), upon starting the service, it
writes an error to the event log that it is unable to allocate that much RAM
(It also writes to the event log that 2048M of RAM was detected).  I can
allocate RAM, provided RAM allocated <= 2048M.

I hope someone has run into an issue like this in the past and can provide
assistance.

Thanks

-Greg