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!
0 Comments:
Post a Comment