SEO

#1 (**permalink**) 02-29-2008, 08:09 PM

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...anytime 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?

#2 (**permalink**) 02-29-2008, 08:09 PM

mchi55@yahoo.com 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...anytime 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/m...S,SQL.90).aspx
--

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

SQL 2000 only using 8GB of 16 GB available