From what I can tell, Win2K Advanced Server has the same issues that WinNT
4.0 Enterprise has. (Using Chap2 of What's New in Windows 2000 Advanced
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