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.