Solved
Windows Server 2003 / SQL Server 2005 potential Memory issue
Posted on 2008-10-07
Hi,
We have a dedicated server with the following spec:
CPU Opteron 1216 HE DC
CPU-Details 2 x 2,4 GHz
RAM 2 GB
Hard Drives 2 x 250 GB
Unlimited Traffic
100 MBit bandwidth
On the server we only have website files (40MB) in wwwroot and a one SQL Server 2005 database which has 12 tables, only one of which Id consider large, which all of the website pages connect to for content.
There is 6.5GB of free space on the C: drive (though itll be back up to about 8.5GB when Ive completed this weeks clearance of mailroot\badmail folder contents) but the server keeps running out of RAM.
Im currently setting up user registration for the site, which involves sending out automatic verification emails, but I keep getting the following error when completing the ASP.Net 2.0 form and the email tries to send:
Insufficient system storage. The server response was: 4.3.1 Out of
memory
If I reboot the server and clear the RAM the emails send without any errors for a short time, before the problem returns.
Ive reported this to the server providers and they believe it is a RAM problem, backed up by the fact that after a few days without a reboot, remote desktop connections to the server are slow and the site itself can run quite slowly (pages taking a while to load)
The server providers solution is obviously to upgrade our package, but is there anything you can suggest doing to the memory usage of SQL server or the server itself to reduce this problem? Or CPU usage?
As I only have remote desktop connections to the server I can not access the Windows Task Manager to check on memory usage.
Thank you for any help you can offer