QuickTricks: Fixing dashboards which do not display performance metrics after upgrade

During a recent upgrade to SCOM 2012 R2 and UR1 and we started seeing issues with dashboard displaying performance metrics as shown below. The details of the error are below: Microsoft.EnterpriseManagement.Presentation.DataAccess.DataProviderException: An error occurred executing the command: [Microsoft.EnterpriseManagement.Presentation.DataProviders.Library!PerformanceDataProvider/ResolvePerformanceCounterSeries] in provider: [Microsoft.EnterpriseManagement.Presentation.DataProviders.PerformanceDataProvider, Microsoft.EnterpriseManagement.Presentation.DataProviders.Library, Version=7.0.5000.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35].Unable to execute stored procedure needed for dashboard.  If you just…