Sawmill Server DB

spoonman_ironport · ‎01-22-2009

Does the Sawmill software have its own DB maintenance? Will just keep growing the Disk if something isn't setup ?? I have a Server with a 30GB drive running sawmill....I see the disk drive growing, shoul i set some automatic maintenance somewhere??
thanks

jowolfer · ‎01-23-2009

Sawmill does not automatically prune data from the data base. However, you can schedule various DB maintenance tasks from within sawmill.

Depending on your data set size, 30 GB may not be enough. In order to perform DB prunes, Sawmill requires between 2 - 3 times the amount of space as the DB size.

So if you have a 10GB DB, you'll need up to 30GB to properly prune the database. Also don't forget, that if you're storing your log files on the same Sawmill server, the original logs also consume space.

It is recommended to have much more disk space. Though if your DB is very small and you won't be storing a long history, you may be fine with 30GB.

ross.filipek · ‎06-11-2009

Sawmill does not automatically prune data from the data base. However, you can schedule various DB maintenance tasks from within sawmill.

Josh--

Is there a Sawmill reference that describes how to do the pruning? I didn't see anything that looked quite like that in the user guide, but there's probably something I'm missing. Thanks in advance.

JennieMorton · ‎06-11-2009

Is there a Sawmill reference that describes how to do the pruning? I didn't see anything that looked quite like that in the user guide, but there's probably something I'm missing. Thanks in advance.

The Sawmill for IronPort User Guide is geared mostly toward the plugin that IronPort created and how it works with Sawmill itself. For any other tasks specific to using Sawmill, your best source of help is the original Sawmill documentation which you can find on Flowerfire's site.