I created a small management pack a couple years ago to help identify performance bottlenecks in an Operations Manager 2007 R2 environment.  It started with a couple collection rules targeting the core SCOM server roles.  I would then query the database and paste results into an Excel spreadsheet...