SCOM – Where is your Perf Data Coming From?

Kevin Holman has already published the SCOM SQL bible - but I've one update.

When trying to see where your performance data is, I've added a "rule" column to one of Kevin's queries making it easier to track down and override those data hogs!

Use OperationsManager
select top 20 pcv.ObjectName, pcv.CounterName, r.RuleName, count (pcv.countername) as Total
from performancedataallview as pdv, performancecounterview as pcv, rules as r
where (pdv.performancesourceinternalid = pcv.performancesourceinternalid) and (r.RuleId = pcv.ruleid)
group by pcv.objectname, pcv.countername, r.rulename
order by count (pcv.countername) desc




Comments (0)

Skip to main content