Rotate event tables and alert table cleanup

The growth of data tables impedes performance. Preserve instance performance by event table rotation and alert table cleanup for status and alert history retention.

Containing the growth of event tables

By default, the Event Management event [em_event] table uses table rotation. The table rotation schedule ensures that new data is written to one of the tables in the rotation group. According to the value of Clean base rotation setting, the base table is deleted and then a new round of writing the tables in a daily rotation commences. By default, this table deletion occurs after seven rotations.

To back up events to a custom table, see Event Management best practices.

Containing the growth of alert tables

By default, a scheduled job cleans out the alert [em_alert] table. Alert table cleanup is recommended for status and alert history retention.