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

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.

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.