Hello, we are pondering the idea of starting a brand new UIM database. Basically due to the fact that our have grown to almost 1TB and the performance is really bad in the UMP. Loading data take a very long time for metrics to show up in the UMP USM page for hosts.
We were thinking of moving the existing database over to an archived database which would be used for just reporting purposes. I wanted to know what or how should we go about re-creating the database from a fresh start then point the existing environment to the same database?
What would be our best options here?
1. Make the backup copy it over to archived machine?
2. Then on existing SQL box do a shrink down to a small file size?
Just lookign for ideas, suggestions? Thank you.