This recipe covers how to optimize the DPM database also known as DPMDB.
In larger deployments of System Center Data Protection Manager, it is important to keep track if DPM and its underlying architectural dependencies are functioning optimally. This can be done by levering the possibilities of proactive monitoring using System Center Operations Manager and corresponding management packs.
If you don't have System Center Operations Manager installed, consider implementing it as soon as possible in order to enable a proactive monitoring for your data center that is adaptive and optimized for the Microsoft product stack.
To determine whether or not the DPMDB needs to be optimized, perform a search in the Recovery view of the DPM console. Search for Exchange and or SharePoint data. If the time for search takes very long, you should consider optimizing the DPMDB.