大网数据广告活动
启动与系统组件

Performance views still show deleted counters

· 52CE 我爱测

Fixes an issue in which performance views still show counters when performance collection rules are disabled in Microsoft System Center Operations Manager.

This article helps you fix an issue in which performance views still show counters when performance collection rules are disabled in Microsoft System Center Operations Manager.

Original product version:   System Center 2012 R2 Operations Manager, Microsoft System Center 2012 Operations Manager
Original KB number:   3002249

Symptoms

When performance collection rules are disabled in System Center Operations Manager, performance views still show counters even after all the data is groomed out.

This clutter PerformanceDataAllView, in extreme cases, can make the view difficult to use because of the number of counters that are selected.

Cause

This issue is by design. The Operations Manager grooming processes don't groom the PerformanceSource table.

Resolution

The following example 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
)

If you want to see which performance counters will be deleted for what objects before you run the delete script that's listed before, first run the following script:

Use OperationsManager select PS.PerformanceSourceInternalId, BME.BaseManagedEntityId, BME.DisplayName, PC.CounterName, PC.ObjectName, PS.TimeAdded, PS.LastModified, PDA.PerformanceSourceInternalId from PerformanceSource PS left join PerformanceDataAllView PDA on PDA.PerformanceSourceInternalID = PS.PerformanceSourceInternalId join PerformanceCounter PC on PC.PerformanceCounterId = PS.PerformanceCounterId join BaseManagedEntity BME on BME.BaseManagedEntityId = PS.BaseManagedEntityId where PDA.PerformanceSourceInternalId IS NULL

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 04/15/2024
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。