Sql-Server not allocating all its configured memory

Hi,
Its a 8GB w2k Advanced Server with SQL Enterprise Edition. PAE and 3GB Flags
are set in boot.ini, awe is enabled for the sql server.
The sql server is configured to allocate as much as 7 GB, but only gets 4.

Anyone got a clue?

Silly question but has to be asked.
Has the server been re-booted since making the changes?

--
Nik Marshall-Blank MCSD/MCDBA

"Michael Sander" <spam@h3c.de> wrote in message
news:uZUDmmzwFHA.460@TK2MSFTNGP15.phx.gbl...
> Hi,
> Its a 8GB w2k Advanced Server with SQL Enterprise Edition. PAE and 3GB
> Flags are set in boot.ini, awe is enabled for the sql server.
> The sql server is configured to allocate as much as 7 GB, but only gets 4.
>
> Anyone got a clue?
>

;)
yes, a couple of times...

There are also no other apps running that could take that amount of memory
away from the server...


"Nik Marshall-Blank (delete fcom for my email address)"
<NikMB@fcomiNodefcom.afcomt> schrieb im Newsbeitrag
news:rG8_e.108163$Fp4.21192@fe09.news.easynews.com...
> Silly question but has to be asked.
> Has the server been re-booted since making the changes?
>
> --
> Nik Marshall-Blank MCSD/MCDBA
>
> "Michael Sander" <spam@h3c.de> wrote in message
> news:uZUDmmzwFHA.460@TK2MSFTNGP15.phx.gbl... 
>
>

also tried to run this without the 3gb flag, but it didn't make any
difference...

"Nik Marshall-Blank (delete fcom for my email address)"
<NikMB@fcomiNodefcom.afcomt> schrieb im Newsbeitrag
news:rG8_e.108163$Fp4.21192@fe09.news.easynews.com...
> Silly question but has to be asked.
> Has the server been re-booted since making the changes?
>
> --
> Nik Marshall-Blank MCSD/MCDBA
>
> "Michael Sander" <spam@h3c.de> wrote in message
> news:uZUDmmzwFHA.460@TK2MSFTNGP15.phx.gbl... 
>
>

please post the results of exec sp_configure

--
Nik Marshall-Blank MCSD/MCDBA

"Michael Sander" <spam@h3c.de> wrote in message
news:%23B9BmN1wFHA.3588@tk2msftngp13.phx.gbl...
> also tried to run this without the 3gb flag, but it didn't make any
> difference...
>
> "Nik Marshall-Blank (delete fcom for my email address)"
> <NikMB@fcomiNodefcom.afcomt> schrieb im Newsbeitrag
> news:rG8_e.108163$Fp4.21192@fe09.news.easynews.com... 
>
>

cant for the moment, our customer ist just reinstalling it. will do in the
next days...

"Nik Marshall-Blank (delete fcom for my email address)"
<NikMB@fcomiNodefcom.afcomt> schrieb im Newsbeitrag
news:pT9_e.146519$B_6.39519@fe05.news.easynews.com...
> please post the results of exec sp_configure
>
> --
> Nik Marshall-Blank MCSD/MCDBA
>
> "Michael Sander" <spam@h3c.de> wrote in message
> news:%23B9BmN1wFHA.3588@tk2msftngp13.phx.gbl... 
>
>

I think I found the solution:

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

Theres a known bug in sp4 for sql server with awe enabled.

Cant test it right know since we need to test sp4 first, but it sounds quit
good.

Excellent.
Sounds about right to me too!

--
Nik Marshall-Blank MCSD/MCDBA

"Michael Sander" <spam@h3c.de> wrote in message
news:%23HTkK5OxFHA.1256@TK2MSFTNGP09.phx.gbl...
>I think I found the solution:
>
> http://support.microsoft.com/default.aspx?kbid=899761
>
> Theres a known bug in sp4 for sql server with awe enabled.
>
> Cant test it right know since we need to test sp4 first, but it sounds
> quit good.
>
>