Product manual

GFI EventsManager 14 Database Maintenance | 250
14.1.5 Configuring database rotation options
When processing events from a large number of event sources, it is important to configure database
rotation options. These options instruct GFI EventsManager to automatically switch to a new
database when a certain condition is met. Doing so helps you maintain a pool of fixed size databases
which enable GFI EventsManager to perform better.
When a database becomes too large in size, queries take longer to complete so therefore, GFI
EventsManager performance is affected negatively.
For example, if your event sources normally generate a lot of small sized event logs, enable database
rotation for when a maximum number of records is reached. On the other hand, if the size of event
logs that your event sources are generating is large, configure database rotation for when the
database reaches the size limit.
To configure database rotation options:
1. Click Configuration tab > Options.
2. From Configurations, click File storage > Configure file storage…
Screenshot 204: Configuring database rotation options
3. Click Enable database rotation.
4. Configure the options described below: