Automatically pulled from Google Starred
DPM is largely depending on its SQL database. All settings, jobs and recovery information is hold in the DPM database.
When the DPM database has performance issues then this will also impact the performance of the DPM console.
One of the possible performance issue are fragmented Indexes in your database.
The Report Index Physical Statistics show the status of the fragmentation
When the indexes are heavily fragmented then you need to rebuild them. You can do that by hand, but that’s a ‘hell of a job’.
Therefor I use the script below which will rebuild every index existed in database with fillfactor of 80.