Microsoft recently released KB3002249 which details an issue whereby when performance collection rules are disabled in SCOM, performance views still show counters even after all the data is groomed out.
This effects all versions of SCOM and can make the PerformanceDataAllView difficult to read due to clutter.
“This issue is by design. The Operations Manager grooming processes does not groom the PerformanceSource table.”
The below query can be used to see which performance counters will be deleted for what objects before you run the delete script:
The following is a small SQL script that will remove the entries from PerformanceDataAllView for which no data is recorded.
Note Stop all the Operations Manager services on all Management Servers before you run the script. Always back up your OperationsManager Database before you run this script.
Use OperationsManager delete from PerformanceSource where PerformanceSourceInternalId in ( select PS.PerformanceSourceInternalId from PerformanceSource PS left join PerformanceDataAllView PDA on PDA.PerformanceSourceInternalID = PS.PerformanceSourceInternalId where PDA.PerformanceSourceInternalId IS NULL )