Archive records from Large Table

[Dhimple Balakri]

We need to archive records from a table with approximately 2,600,111,136 records. However, archiving records created before 18 months is taking too long. Does anyone have suggestions on how to speed up this process? Considering the number of records, will increasing the batch size cause any performance issues?

[Viraj Hudlikar]

Hello @Dhimple Balakri 

Have a look on below articles which could help you.
(2) Data Archiving Walkthrough - ServiceNow Community

Archiving | General Overview - Support and Troubleshooting

Solved: What is the best practice for setting up data arch... - ServiceNow Community

If my response has helped you hit helpful button and if your concern is solved do mark my response as correct.

Thanks & Regards
Viraj Hudlikar.

[Dhimple Balakri]

Hi,
Thank you for your response. I have created an archival rule, but it is taking time to archive records. I would like to know how we can increase the speed of archiving in my case and whether it will cause any performance issues.
Thank you!

[Viraj Hudlikar]

@Dhimple Balakri  - If the data is huge, it will take time, in our case we divided the data chunk in multiple condition and created multiple rules for same and relatively it archived data. To avoid performance impact, we used to run this rule in our off-business hours.

If my response has helped you hit helpful button and if your concern is solved do mark my response as correct.

Thanks & Regards
Viraj Hudlikar.

[Viraj Hudlikar]

Hello @Dhimple Balakri 

Thank you for marking my response as helpful! 😊

I hope your concern has been fully addressed. If it resolves your issue, please consider marking it as the accepted solution. This will ensure others in the community can benefit from the solution too.

As per new community feature you can mark multiple responses as correct.

Thanks & Regards
Viraj Hudlikar.