|
|
Posted by David Portas on 08/15/06 20:50
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/ms130214(en-US,SQL.90).aspx
--
Navigation:
[Reply to this message]
|