| Author |
Sql-Server not allocating all its configured memory
|
|
| Michael Sander 2005-09-27, 3:23 am |
| 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?
| |
| Nik Marshall-Blank \(delete fcom for my email addr 2005-09-27, 7:23 am |
| 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?
>
| |
| Michael Sander 2005-09-27, 7:23 am |
| ;)
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...
>
>
| |
| Michael Sander 2005-09-27, 7:23 am |
| 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...
>
>
| |
| Nik Marshall-Blank \(delete fcom for my email addr 2005-09-27, 7:23 am |
| 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...
>
>
| |
| Michael Sander 2005-09-27, 9:23 am |
| 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...
>
>
| |
|
|
| Nik Marshall-Blank \(delete fcom for my email addr 2005-09-29, 9:23 am |
| 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.
>
>
|
|
|
|