Home > IT Answers > SQL Server > SQL Server 2005 Memory
Uphs
25 pts.
 SQL Server 2005 Memory
SQL Server 2005, SQL Server memory, SQL Server performance, SQL Server performance tuning, Windows XP
SQL server 2005 running on windows XP, memory grows steadily then SQL(system) hangs when memory gets to 1.7 gb...Server must be re-started. What could cause this?

Software/Hardware used:
ASKED: January 26, 2009  1:22 PM
UPDATED: January 29, 2009  3:31 PM
RELATED QUESTIONS
Answer Wiki:
How big is the database? What edition or SQL are you running ( Developer since you are running XP and Express only uses 1 Gig of RAM)? How much RAM do you have? Odds are the database server needs more RAM than you have available. The Developer edition of SQL Server can only use 2 Gigs of RAM since it is for development use. To use more than 2 Gigs of rAM you'll need to move to a server OS, and install Standard or Enterprise edition of SQL.
Last Wiki Answer Submitted:  January 27, 2009  1:23 am  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:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Thanks for resonding, it’s running Workgroup edition 9.0.3042 , database is 2 gb, and there 3gb of ram available.

Uphs
 25 pts.
 

Workgroup supports up to 3 Gigs of RAM, but to go above 2 Gigs of RAM you’ll need to enable AWE within the database and PAE at the OS level (which I’m not sure if XP supports).

Assuming that you enable AWE there probably isn’t enough RAM available on the machine to let SQL take any more RAM.

Denny Cherry
 64,520 pts.
 

Thank you. I am moving the DB to a more stable/standard server..

Uphs
 25 pts.