How do I configure SQL 2005 to use 22GB RAM on a Server with 24 GB RAM running Windows 2003 EE ?
Home > IT Answers > SQL Server > How do I configure SQL 2005 to use 22GB RAM ...
Ravikswamy
20 pts.
0
Q:
How do I configure SQL 2005 to use 22GB RAM on a Server with 24 GB RAM running Windows 2003 EE ?
SQL Server 2005, SQL Server memory, SQL Server configuration
We have Windows 2003 Enterprise Edition (32bit) running on a IBM Quad Core Xeon Dual processor system with 24 GB RAM. The same server runs SQL 2005 with SP2. How do I configure SQL Server to use the maximum RAM say upto 22GB RAM ?
ASKED: Sep 27 2008  4:57 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
In the boot.ini you need to add in the /PAE and /3GB switches.

Within SQL Server you need to use sp_configure to enable AWE. Set the maximum server memory to 22528.

exec sp_configure 'allow AWE', 1
 exec sp_configure 'max server mem', 22528
 reconfigure
 go


After doing this you will need to reboot the server.
Last Answered: Sep 27 2008  9:39 PM GMT by Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0