SBS 2003 stops to respond often due to limited memory

Posted by Sanoj on Server Fault See other posts from Server Fault or by Sanoj
Published on 2010-03-15T10:25:45Z Indexed on 2010/03/15 10:50 UTC
Read the original article Hit count: 429

I have a Windows SBS 2003 Std that regularly stops to respond (crashes), in about every 20th day. The only thing I can see in the logs (the one that are mailed to the administrator) is that used memory increases with about 30MB/day. The process that uses more and more memory is sqlservr. We don't have much installed on the server; a Point-Of-Sale-system that uses Pervasive SQL as database and an Accounting application. We just have 2GB of RAM and I could upgrade to 4GB but I think that this just delay the problem.

When the server stops to respond, the screen saver cannot be deactivated, no DNS-look-ups is working so the client's can't access Internet. And applications on the server do not reply. And we have to press the power-button to restart the server.

For the moment it has an uptime of 19 days and have 2 345MB in memory use (idle) and sqlservr is using 819 MB. So I guess it will crash soon.

Is there any solution to this problem? Could I limit sqlservr to some memory?

© Server Fault or respective owner

Related posts about sbs-2003

Related posts about memory-leak