I thought I was done doing DBA work when I retired. I’m getting to the point where I’m considering just deleting the database monthly. The whole idea of keeping what I would call “archival” data in the same database as real-time data is a problem right from the start. And the “one size fits all” retention period for all data is just poor design.
I already keep the most critical data (to me) elsewhere. I’m thinking about doing the same for the less critical stuff that I like to retain for different intervals.
I know a lot of work has gone into tweaking the database, and I appreciate that. But at some point it’s going to take more than tweaks to achieve a stable, long-term solution.