Monday, February 2, 2015

Remove duplicate Performance Entries

A couple of weeks ago, Microsoft released a new MP version for Windows Server Operating System. The version number was 6.0.7294.0 and it brought some fixes for Mount Point monitoring and unfortunately some bugs related Logical Disk discovery, monitoring and performance collection.

Since last Friday they released a fixed version (6.0.7296.0):
http://www.microsoft.com/en-us/download/details.aspx?id=9296

After importing the new version everything looks good but the multiple entries in the Performance Views remain.

Below you can find the SQL statements to get rid of them. Always keep in mind that manipulating the database directly is completely unsupported! Everything you do here is on your own risk! Try in lab before!

Let’s go…

Show all Logical Disk performance entries where the Display Name is not equal the Instance Name:

Use OperationsManager
select PS.PerformanceSourceInternalId, BME.BaseManagedEntityId, BME.DisplayName, PS.PerfmonInstanceName, 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 ObjectName = 'LogicalDisk'
      and DisplayName like '%:%'
      and DisplayName <> PS.PerfmonInstanceName
      or ObjectName = 'LogicalDisk'
      and DisplayName like '\\?\Volume%'
      and DisplayName <> PS.PerfmonInstanceName

Attention: backup your Operational Database before you move on!

Delete all Logical Disk performance entries where the Display Name is not equal the Instance Name:

Use OperationsManager
delete from PerformanceSource where PerformanceSourceInternalId in
(
select PS.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 ObjectName = 'LogicalDisk'
      and DisplayName like '%:%'
      and DisplayName <> PS.PerfmonInstanceName
      or ObjectName = 'LogicalDisk'
      and DisplayName like '\\?\Volume%'
      and DisplayName <> PS.PerfmonInstanceName
)

After that, the duplicate entries in the performance view will disappear.

Good luck!

All information is provided "as is" without any warranty! Try in lab before. Handle with care in production.

0 Comments:

Post a Comment