Purge unused entities from long term database

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.

Update: I was able to prevent my entities from recording LTS data, and clearing these data from the database.
I posted more info on another thread, here.