SQL Server 2005 memory issue

25 pts.
Tags:
SQL Server 2005
SQL Server memory
SQL Server performance
SQL Server performance tuning
Windows XP
SQL server 2005 running on Windows XP. The memory grows steadily then SQL (system) hangs when memory gets to 1.7 GB and then the server must be re-started. What could cause this?
ASKED: January 26, 2009  1:22 PM
UPDATED: June 26, 2013  5:43 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Uphs
    Thanks for resonding, it's running Workgroup edition 9.0.3042 , database is 2 gb, and there 3gb of ram available.
    25 pointsBadges:
    report
  • Denny Cherry
    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.
    65,485 pointsBadges:
    report
  • Uphs
    Thank you. I am moving the DB to a more stable/standard server..
    25 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following