Groups | Blog | Home
all groups > sql server (microsoft) > february 2006 >

sql server (microsoft) : Memory Allocation - Win2k3 SP1 and SQL Server 2K SP4


nicholasbecker NO[at]SPAM gmail.com
2/24/2006 12:33:02 PM
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
aaron.kempf NO[at]SPAM gmail.com
3/21/2006 4:17:33 PM
you got the 3gb switch in your boot.ini?

what edition of SQL Server are you running? Standard or Enterprise?

which edition of Windows 2003 are you running?

or is it Windows 2000?
AddThis Social Bookmark Button