Are you using ArcGIS Online or ArcGIS Enterprise? If you are using ArcGIS Enteprise, I believe you can put change your service pooling or other parameters in that related service Tune and configure services—ArcGIS Server | Documentation for ArcGIS Enterprise. However, I think it's not the best practice in the short term.
If it still not satisfying, usually I created a task scheduler in the backend to record the old from the business table to the backup table. In my previous client, I had more than 1 million rows, due to the update of data are fast and massive. So I created a task scheduler ran every 6 hours to record more than 3 days old data.
Hope, it helps you
Cheers