SQL Server 2005 Memory
Home > IT Answers > SQL Server > SQL Server 2005 Memory
Uphs
25 pts.
0
Q:
SQL Server 2005 Memory
SQL Server memory, SQL Server 2005, Windows XP, SQL Server performance, SQL Server performance tuning
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?
ASKED: Jan 26 2009  1:22 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0
  • AddThis Social Bookmark Button
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 Answered: Jan 27 2009  1:23 AM GMT by Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Uphs   25 pts.  |   Jan 27 2009  2:12PM GMT

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

 

mrdenny   46795 pts.  |   Jan 28 2009  8:05PM GMT

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.

 

Uphs   25 pts.  |   Jan 29 2009  3:31PM GMT

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

 
0