Friday, 10 February 2012

Configure SQL Server 2000 for more than 2GB RAM on Windows 2000 server

Hi,

I've a SQL Server 2000 (SP4) installed on Windows 2000 Server.
The system has 4GB RAM.

SQL Server not using more than 2GB RAM even I set the following.

AWE enabled.
Max server Memory (MB) : 3GB
SQLService account is enabled for "Lock Pages in Memory"

Can you please help what I'm missing here?
Thanks in advance.

Regards,
Mkarumuru

have a link from Microsoft that explain this subject:

http://support.microsoft.com/kb/274750/en-us

if you use SQL Server 2000 Standart, then only use 2 GB

|||Thanks for the quick reply.
Its very useful.

I've SQL Server 2000 Standard Edition.
So I cannot use more than 2 GB RAM.

Regards,
MKarumuru

No comments:

Post a Comment