SBS 2003 crashes 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:30 UTC
Read the original article Hit count: 430

I have a Windows SBS 2003 Std that regularly crashes, in about every 20th day. The only thing I can see in the logs 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.

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