Print Page | Close Window

Memory Issues

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=4577
Printed Date: 18 September 2025 at 12:17am


Topic: Memory Issues
Posted By: Guests
Subject: Memory Issues
Date Posted: 16 November 2004 at 10:45am

Twice this week, we've had to restart Spamfilter due to memory issues. The Spamfilter stops delivering email to the actual mailserver. MS SQL seems to be using a majority of the memory and the system's page file is rather large. The computer has dual zeon 2.8ghz processors, 1024mb of RAM and SCSI hard drive. I woud think the system is sufficient to run the Spamfilter as it is all the system is used for. Is there some settings that we need to change as far as memory usage for SQL? Do we need more RAM?

You should have a log and ini file that was recently sent to you from Greg (‘Quarantined Unfiltered Email’) in regards to another issue.

Any help would be appreciated.

Thanks,
James


Replies:
Posted By: LogSat
Date Posted: 16 November 2004 at 10:57pm
Greg,

SQL Server will often take over *any* free memory available on the server even if it's not really needed... Please check in the SQL Server Properties if SQL Server is set to "Dynamic memory configuration". If so, we'd recommend you change that and assign a fixed memory size to SQL Server. Usually you'll gain in performance as there's less file fragmentation, and the server will have room to breath as RAM will be available for other applications.

In addition, can you please ensure that in SpamFilter's quarantine view, you hide the quarantined email list when finished using it? Keeping the DB connection open to display the emails can and will consume large amounts of RAM and will degrade performance.

Roberto F. LogSat Software

Posted By: Guests
Date Posted: 17 November 2004 at 9:38am

We thought about doing that, but was not sure how much memory to allocate to SQL. I'm not sure how much to give with out affecting the performace of Spam Filter.


Posted By: LogSat
Date Posted: 17 November 2004 at 3:01pm
We tried to make SpamFilter as efficient and "slim" as possible. The amount of RAM used by SpamFilter depends on several factors, the most important of which are the amount of email traffic and whether or not you are using the Bayesian statistical filter (the filter requires RAM). Assuming that the Bayesian filter is active and you're receiving about 10,000 emails/day, SpamFilter should on average need 100-150MB of RAM.

Roberto F. LogSat Software

Posted By: Desperado
Date Posted: 17 November 2004 at 7:04pm

I run with a 4 processor machine with 2GIG of RAM.  I have MSSQL set to use only 3 processors and to only grab 800MEG of the ram.

On my test server, I have a 2 processor machine with 512MEG.  I set MSSQL to use both CPUs and limit the RAM to 100MEG.  In both cases I have zero performance issues.

The first server is running 12 instasnces of SpamFilterISP and receives around 200K Messages / day with a database of around 4GIG with 500K messages in it.

The second server is a single instance and only receives about 600 messages / day (as it is a bogus domain I use for testing)

Regards,

Dan S.

Posted By: Guests
Date Posted: 18 November 2004 at 9:59am

Dan & Roberto,

Thank you for all the help. I limited SQL to 512 and it seems to work fine. I'll let you know if there are anymore problems. Windows is no longer using the pagefile which is good.

Greg


Print Page | Close Window