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

Means to access SQL w/o EM

Hey folks,

Here's my situation. My web host has enabled SQL 2000 for my account but has left it to me to connect to it. I don't have the money to spend to buy the SQL Server 2000 software myself so I can get Enterprise MAnager. Is there some way, perhaps open source, that would allow me to interface even through a command line with SQL? I am a bred and bled MySQL man but I am trying to get a hang of SQL so I will be more adequetly prepared for a potential job I may have in the near future.

SketchI know that you can download the trial version of SQL Server 2000
Trial Version (http://www.microsoft.com/sql/evaluation/trial/2000/default.asp)
You only need the client tools, so just install them. The trial version is limited to a 120 days, but I wonder if that is on the Server/Database? You could try and install the client tools only.

I've downloaded and installed this product, because it works with all ADO supported RDMS.
Query Tool (using ADO) (http://gpoulose.home.att.net/)|||Yes, 120 days trial version of SQL Server might be your answer for now, however keep in mind, that you need server type of O/S (2000 Server or NT Server) to install instance of SQL Server itself.
You can download it or buy it on CD with many SQL Server books and then just download SQL S. Service Pack 2 from http://www.microsoft.com/downloads/search.asp?

Workstation such as Win 2000 Pro allows for client tools only and yes, you get Enterprise Manager with it.
With this option you need permission from the actuall SQL Server to connect to it.