Home > IT Answers > SQL Server > Is it possible to increase the amount of memo...
Help

Question

  Asked: Apr 25 2008   2:27 PM GMT
  Asked by: SQL Server Ask the Experts

Is it possible to increase the amount of memory used by SQL Server 2005 to speed up response time?


SQL Server performance tuning, SQL Server 2005, SQL Server memory

We have 1 server Proliant ML570T04 with 16GB di ram and 11 SAS Disk 70 gb. The software installed is SQL Server 2005, 32-bit and the application is Navision. With < 15 clients, the response time is slow because the SQL Server utilizes only 4 GB of ram. Is it possible to utilize the remaining memory, and if so, how?

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


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

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

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Apr 25 2008  9:26 PM GMT  by Mrdenny




If you have Windows 2003 Enterprise Edition installed then yes. If you have Windows 2003 Standard Edition installed you are limited to only 4 Gigs of RAM.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on SQL Server.

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


RSS - Discussions Help

Discuss This Answer


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