AnsweredAssumed Answered

Archive and Purge - Slow down the rate of purging

Question asked by john.wohlgemuth on Jul 18, 2017
Latest reply on Aug 10, 2017 by john.wohlgemuth

We need to run the archive and purge process with the following goals:

  • Keep SDM online 24/7
  • Ensure the MSSQL transaction log size is manageable (if the log fills up, SDM will crash).
  • Minimize or eliminate SQL blocking during purging
  • We need to purge 5+ million call_req records.

 

How can I configure the purge to delete call_req and related records at a particular rate, such as 10 call_req records per minute?  I need to slow down the rate to maintain the goals above.

 

Thanks,

 

John

Outcomes