How to manage the SQL DM Repository database for keeping 6 montn retention of history and snapshots

by Feb 17, 2017

 
Our business requirements  we need to keep the 6 month old history and snapshot datas . SQL DM Repository database size reached 3 TB.Because of database size increasing data collection performance reducing. So Please suggest the best grooming techniques to managing the SQL DM Repository database.
 
And please share the  best practice to managing the database SQL Dm Repository database .. Thanks a lot