Home > IT Answers > Development > SQL Server 2005 Memory
Rick Martinez
585 pts.
 SQL Server 2005 Memory
SQL, SQL 2005, SQL Server, SQL Server 2005, SQL Server memory
I have a server with 8 dual core processors, 32GB of RAM, windows server 2003 32bit, sql server 2005 enterprise, and a 500GB database running on it.

1. How does sql server use memory in this case?

2. I have heard from sql server pro's that sql server can only use 4GB of RAM is that true?



Software/Hardware used:
SQL SERVER 2005
ASKED: October 26, 2010  1:54 PM
UPDATED: October 26, 2010  6:26 PM
RELATED QUESTIONS
Answer Wiki:
If you don't have AWE then SQL Server can only use 2 Gigs of memory. With AWE the SQL Server can use the rest of the memory for the buffer cache. The private memory and procedure cache will stay within the first 2 Gigs.
Last Wiki Answer Submitted:  October 26, 2010  6:26 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _