Hi experts,
I was checking the most noisy monitors and it looks like I have thousands of state changes incoming from the MonitorID ProHostVMMemoryPressureUnitMonitor, with different monitor names - one per language and I have around 15 languages there! I checked the
XML of the management pack and they all seem to be embedded there, is there no way of getting rid of all of them other that disabling the whole monitor? I have Japanese, Polish, Hungarian, Portuguese and all of them produce exactly the same number of status
changes - thousands per day. Am I missing something or is it just a bad MP design? Anyone else running this management pack could check the situation in their OPsDb with this query?
SELECT DISTINCT
TOP
50
count(sce.StateId)
as StateChanges,
m.DisplayName as MonitorName,
m.Name as MonitorId,
mt.typename AS TargetClass
FROM StateChangeEvent sce
with (nolock)
join state s
with (nolock)
on sce.StateId
= s.StateId
join monitorview m
with (nolock)
on s.MonitorId
= m.Id
join managedtype mt
with (nolock)
on m.TargetMonitoringClassId
= mt.ManagedTypeId
where m.IsUnitMonitor
= 1
-- Scoped to within last 7 days
AND sce.TimeGenerated
>
dateadd(dd,-7,getutcdate())
group
by m.DisplayName, m.Name,mt.typename
order
by StateChanges
desc
