Memory Allocation - Win2k3 SP1 and SQL Server 2K SP4

I have a SQL Server cluster with 4 Dual Core 3.0Ghz Processors and 8 GB
of RAM. I have PAE and AWE enabled on the server, but I cannot get SQL
Server to access more than 4GB of RAM (using perfmon- SQLServer:Memory
Manager/Total Server Memory). I would like to allocate nearly all of
the available memory on the machine to SQL Server.
I seem to have the same symptons described in this MS article-
http://support.microsoft.com/default.aspx?kbid=899761, but I get a "No
Qualifying Products" error when I try to install the HOTFIX.
Any help would be greatly appreciated.
NickHi
appologies if this is an obvious response - are you using std or ent?
the hotfix is for ent and dev editions.
nicholasbecker@.gmail.com wrote:
> I have a SQL Server cluster with 4 Dual Core 3.0Ghz Processors and 8 GB
> of RAM. I have PAE and AWE enabled on the server, but I cannot get SQL
> Server to access more than 4GB of RAM (using perfmon- SQLServer:Memory
> Manager/Total Server Memory). I would like to allocate nearly all of
> the available memory on the machine to SQL Server.
> I seem to have the same symptons described in this MS article-
> http://support.microsoft.com/default.aspx?kbid=899761, but I get a "No
> Qualifying Products" error when I try to install the HOTFIX.
>
> Any help would be greatly appreciated.
>
> Nick
>|||Look here on the UPDATE section
http://www.microsoft.com/downloads/details.aspx?familyid=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en
Have you applied this hotfix?
Ben Nevarez, MCDBA, OCP
Database Administrator
"nicholasbecker@.gmail.com" wrote:
> I have a SQL Server cluster with 4 Dual Core 3.0Ghz Processors and 8 GB
> of RAM. I have PAE and AWE enabled on the server, but I cannot get SQL
> Server to access more than 4GB of RAM (using perfmon- SQLServer:Memory
> Manager/Total Server Memory). I would like to allocate nearly all of
> the available memory on the machine to SQL Server.
> I seem to have the same symptons described in this MS article-
> http://support.microsoft.com/default.aspx?kbid=899761, but I get a "No
> Qualifying Products" error when I try to install the HOTFIX.
>
> Any help would be greatly appreciated.
>
> Nick
>|||I'm using Enterprise editiion (req's for a cluster).
The link seems to refer to SQL Server SP4. We are have installed sp4
if that's the hotfix you're referring to.
Nick