Christian,
I had a similar problem for a while, whereby some of the expired entries in the quarantine were deleted correctly, while the rest were not.
I got around the problem by executing a script which deleted any left over entries every day. I also had to go in and manually delete the files in the @quarantine directory, as they slowly filled up the disk.
We spent some time trouble shooting the problem with Vircom, and after much head scratching I simply moved the SQL server to a much more powerful machine.
Even though all the perf monitoring I did on the old machine never showed a heavy load on it, I think it was simply too slow in responding to the Modus auto-cleanup procedure.
Since moving to the new server, the problem has gone away.
I'm not saying this is what you are seeing, but it could be something to consider.
FYI, we store about 1.2 million messages in the Quarantine (6 days worth).
The current machine is a dual xeon 2.4 GHZ with 1 GB Ram.
The old one was a Dual P2 400 with 512 MB Ram.
Both machine are dedicated SQL servers with only the Modus Quarantine
Lapo Nustrini
Seanet Corporation
On Monday, November 10, 2003, at 12:31 PM, Christian Schmit wrote:
* This is the modus mailing list *
We use MS-SQL-2000 server as quarantine database.
We noticed the no quarantine entries get deleted in the SQL database after the auto-cleanup time, which is 5 days in our setup. Therefor we have millions of entries in this database which makes searching quite slow.
So my question is should we delete the quarantine entries in SQL ourselves or should modusmail handle this?
The items in the quaratine mailbox on the server get deleted as they should after 5 days.
Currently we run MM 3.0 but the problem also existed with version 2.x for us.
Christian
** To unsubscribe, send an Email to: [EMAIL PROTECTED] with the word "UNSUBSCRIBE" in the body or subject line.
** To unsubscribe, send an Email to: [EMAIL PROTECTED] with the word "UNSUBSCRIBE" in the body or subject line.
