Home > IT Answers > Microsoft Windows > Allowing SQL Server 2000 Enterprise Edition to utilize free physical memory
SQL Server Ask the Experts
2,585 pts.
 Allowing SQL Server 2000 Enterprise Edition to utilize free physical memory
Memory, SQL Server 2000, SQL Server performance
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?

Software/Hardware used:
ASKED: July 3, 2008  6:16 PM
UPDATED: July 4, 2008  4:56 AM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  July 4, 2008  4:55 am  by  Denny Cherry   64,505 pts.
All Answer Wiki Contributors:  Denny Cherry   64,505 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,505 pts.