We are running Windows 2003 server (cluster) with SQL 2000 Enterprise (cluster). We have 4GB of RAM. I'm getting a little confused over the 3Gb switch, the AWE and the PAE. If we want SQL to be able to use 4GB of RAM (setting SQL to dynamically use what it needs when needed), do I have to use first use the 3Gb switch in the boot.ini file, then the PAE switch then the AWE in SQL? It doesn't seem like a simple change.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Allocating more RAM to SQL
- Thread starter Luvsql
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
That is correct. All three must be set.
It's not a simple change.
Don't forget that after changing the boot.ini you have to reboot the SQL Server.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
It's not a simple change.
Don't forget that after changing the boot.ini you have to reboot the SQL Server.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
