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