DB IO spikes when auditing retention job runs, the retention DB query takes long time to run.
- Given 10M audit events in DB
- Perform some user actions which generates more events.
- Wait for hourly Auditing Retention job to run
- Retention cleans old events without causing DB IO spike
- The DB IO spikes when retention job queries DB
Currently there is no known workaround for this behavior. A workaround will be added here when available