SQL 2000 only using 8GB of 16 GB available

[mchi55@yahoo.com]

I have Windows 2003 Enterprise..../PAE is set.
SQL 2000 ENT, sp4, AWE is set.

In the startup SQL log...I see that AWE is enabled.

If I fix the memory below 8 GIG...it will change to whatever I set it
to...no issues.

However...anyti me I set the memory above 8 GB is doesn't grab it. THe
most it will grab is 8 GB.
I get the message that AWE is enabled...but I also get a cannot
allocate min memory '14000'. The OS has 16 gigs of memory....and it
shows 7 GB free after SQL grabs the initial 8 GB. Why does SQL only
use 8 gigs?

I want it to take the entire 15 gbs. Is something in the OS holding
the memory...even though it shows available?

[David Portas]

Re: SQL 2000 only using 8GB of 16 GB available

mchi55@yahoo.co m wrote:

I have Windows 2003 Enterprise..../PAE is set.
SQL 2000 ENT, sp4, AWE is set.
>
In the startup SQL log...I see that AWE is enabled.
>
If I fix the memory below 8 GIG...it will change to whatever I set it
to...no issues.
>
However...anyti me I set the memory above 8 GB is doesn't grab it. THe
most it will grab is 8 GB.
I get the message that AWE is enabled...but I also get a cannot
allocate min memory '14000'. The OS has 16 gigs of memory....and it
shows 7 GB free after SQL grabs the initial 8 GB. Why does SQL only
use 8 gigs?
>
I want it to take the entire 15 gbs. Is something in the OS holding
the memory...even though it shows available?

Do you have the following hotfix installed?

http://support.microsoft.com/default.aspx?kbid=899761

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:

http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx

--