Use of memory on a 4GB server | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Use of memory on a 4GB server

Hello, I have 4-CPU server with 4GB memory. It is dedicated SQL server. Currently I have Windows 2003 standard edition and SQL 2005 standard edition. It used only about 1,7 GB for the SQL server and 300 MB for other processes (system processes) , task manager showed 2,0 GB of use.
Then I added /3GB switch to boot.ini. After that, system shows use of about 3GB, but SQL stayed on 1,7 GB max (even I set more in properties), the only advantages was, that I could use another 1,3 GB for other applications.
But I would like to give more memory to SQL server. I searched web, but I am still not sure about if it is
-possible on current software or if not,
-what are possibilities how to do that (upgrade to Windows Enterprise is of course much cheaper even with some memory addition, than to buy SQL 2005 Enterprise, will AWE memory help me?) P.S. I can use only 32-bit software.
Check the following article…
http://support.microsoft.com/kb/274750 Make sure you change the "max server memory (MB)" setting and restarted sql services…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
quote:Originally posted by MohammedU Check the following article…
http://support.microsoft.com/kb/274750 Make sure you change the "max server memory (MB)" setting and restarted sql services… MohammedU.
Moderator
SQL-Server-Performance.com
of course i did. See picture1 and pic2 and pic3
But the article from MS is too old and doesn’ deal with SQL 2005.
I don’t think so, refer the text under that KBA:
quote:If you are using SQL Server 2005 to configure memory to use more than 2 GB of physical, see the following topics in SQL Server 2005 Books Online:• Memory Architecture
• Server Memory Options
• Using AWE
• Enabling Memory Support for Over 4 Gb of Physical Memory
• Enabling AWE Memory for SQL Server APPLIES TO
• Microsoft SQL Server 2000 Enterprise Edition
• Microsoft SQL Server 7.0 Standard Edition
• Microsoft SQL Server 2005 Enterprise Edition
Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Do not rely on Task Manager… Use perfmon counters TOTAL SERVER MEMORY and TARGET SERVER MEMORY to check the memory…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
]]>