When performance collection rules are disabled in Microsoft System Center Operations Manager, performance views still show counters even after all the data is groomed out. This clutters the related Views and can make them even useless because too many counters are being shown.
This is by design (yikes!)….
A SQL script removes the entries from PerformanceDataAllView for which no data is recorded. KB3002249 contains the SQL scripts (one for removing the entries, another for showing which performance counters will be deleted for what objects before you run the delete script).
The same KB states: ‘…Stop all the Operations Manager services on all Management Servers before you run the script…’ AND ‘…back up your OperationsManager Database before you run this script…’.
SO BE CAREFULL WITH THIS AND ONLY RUN IT WHEN REQUIRED.