Skip to Main Content
AVEVA Product Feedback


Status Declined
Created by Roger Palmen
Created on Aug 19, 2022

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.
  • ADMIN RESPONSE
    Aug 19, 2022
    Thank you very much for sharing your feedback on the PI Server. After further evaluation, we have decided to decline this item, as we are not planning on implementing it in the near future due to other high priority items across the PI System. Thank you for your feedback, and know that we are listening and reviewing every item that gets submitted!
  • Attach files
  • Roger Palmen
    Reply
    |
    Aug 19, 2022
    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.