SQL server ent 2000 AWE setup win2003 ent 32bit
Posted on 2011-03-09
We are having troubles getting the SQL 2000 to address more memory.
The 2 environments are both win2003 enterprise 32 bit running sql 2000 enterprise (both have sp4, one has the post sp4 hotpatches).
OS has 12 gb and /PAE and /3GB are set. And there is ample memory available for SQL at start up time.
SQL config settings:
min server memory (MB) = 3084
max server memory (MB) = 3084 (would like to bump this up in both cases).
set working set size = 0 (required by vendor)
awe enabled = 1
The service account is running with the "Lock Page in Memory" permission.
And there is ample memory.
Systems have been restarted multiple times.
But we always get the error
"Warning: unable to allocate 'min server memory' of 3084MB."
And SQL server appears to dynamically allocate memory up to about 2.7GB.
The sql error log never reads "Address Windowing Extension enabled"
Nor is there an error telling us it cannot use extended memory.
I am clearly missing a step here, but not sure what.
Thanks for your help.
(The good news is the business finally decided to go to a current 64 bit environment, the bad is that is it is not for another 6 months).