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


SQL Server 2000, Memory, 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?

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


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

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


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



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.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on SQL Server and Microsoft Windows.

Looking for relevant SQL Server Whitepapers? Visit the SearchSQLServer.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Mrdenny  |   Jul 4 2008  4:56AM GMT

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