Posted by mchi55 on 08/15/06 19:43
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?
Navigation:
[Reply to this message]
|