Home > IT Answers > SQL Server > Allowing SQL Server 2000 Enterprise Edition t...

Question

Asked: Jul 3 2008 6:16 PM GMT
Asked by: SQL Server Ask the Experts

Allowing SQL Server 2000 Enterprise Edition to utilize free physical memory

I have two identical SQL Server 2000 Enterprise Editions running on Windows 2003 Enterprise servers. They both have 8GB of RAM with /PAW and /3GB switches configured. The max server memory is set to 7GB on both. On one of the servers, the available physical memory under Task Manager Is always showing 3GB free, yet I cannot get SQL Server to utilize that extra 3GB. Can you offer any advice?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.

Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER

View History

RATE THIS ANSWER

0
Click to Vote:

Last Answered: Jul 4 2008 4:55 AM GMT by Mrdenny

It could simply be that SQL Server on that machine doesn't think that it needs to use the additional memory.

Another possible option is that you have AWE enabled on the server that is using all it's memory, and it's not enabled on the server that is not using all it's memory.