Throttling of Audit Trail cleanup
Currently the Audit Trail cleanup, when turned on, just deletes everything. When there is a large backlog for the cleanup, this causes a huge load on the SQLserver.
I would like some throtthling feature to not load the server too high with the cleanup.
Dealing with the same problem again...
It appears that the cleanup creates one huge transaction to perform the cleanup. If there is a large backup you need ridiculous amounts of logspace to buildup the transaction. At the moment performing a cleanup, and for a audit log of 110Gb i'm already at a logspace of 75Gb
With smaller transactions this would be more efficient.