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