I'm having an issue with the alert table partitions being purged when I think they shouldn't be. This has happened once before around the time another fault was being resolved, but not to such a level and it seemed to sort itself out.
Our event counts have increased so I'm not expecting to retain that many days in normalized events, but less than a week isn't particularly useful. As I type, this morning it has purged the last two inactive partitions, leaving that empty, and has just started to fill the 5th active partition. Previously, it would always tick over with 4 inactive partitions sitting in the storage volume.
Has anyone experienced this and/or has any knowledge how to stop this happening?
We're using 9.5.2 and I have a 217GB share configured for inactive partitions.
Database>Data Retention is set to keep all data allowed by the system, and the NitroTID output shows the following;
Partition Type - Time based partition Total Partitions - 5 Total Active - 5 Total Inactive - 0 Partitioning Field - LastTime Partitioning Time Unit - 1 day(s) Min Records / Partition - 25,000,000 Max Records / Partition - 25,000,000 Allowed Attached - 115,000,000 record(s) OR 5 partition(s) Max Before Deletion - 265,000,000 record(s) OR 11 partition(s) Max Emtpy Gap - 30 partition unit(s)
Partitions on average cover ~30 hours weekdays, 40 or so weekends.