As I'm currently expecting for somebody to advice me on the process which I'm gonna take forward for DB archiving.
I've database(DB-1) which has 2 very large tables, one table having 25 GB of data and another is 20 GB of data. which cause major performance issues even i have indexes.
What I have tried:
So, we can considered to archive the old data with the below process,
1. Clone a new database(DB-2) from existing database(DB-1).
2. Delete an old data from DB-1, so it will have only the last 2 years records.In case If I need old data can connect DB-2.
3. Every month should move an old data from DB-1 to DB-2, and delete
the moved records from DB-1.