i am looking for some custom scripts to pull information on perfomance data counters being collected by OpsMgr. Does anyone have any scripts they are currently using?

  • What language? .NET? Powershell? – SQLChicken May 27 '09 at 17:48
  • wow, didn't think about the other options, but i was only thinking about t-sql with the idea of building some custom reports. but i suppose i would take whatever anyone has to offer. – SQLRockstar May 27 '09 at 18:00

Here's some sql to get you started:

use operationsmanagerdw
SELECT TOP 100 pr.ObjectName, pr.CounterName, pri.InstanceName,
FROM Perf.vPerfRaw p
INNER JOIN vManagedEntity me ON me.ManagedEntityRowID =
INNER JOIN vPerformanceRuleInstance pri ON pri.PerformanceRuleInstanceRowId
= p.PerformanceRuleInstanceRowId
INNER JOIN vPerformanceRule pr ON pr.RuleRowId = pri.RuleRowId
WHERE me.[Path] = 'server FQDN'

Works with SCOM 2007 SP1, SQL 2005 backend. Other performance tables in the data warehouse are Perf.vPerfHourly , and Perf.vPerfDaily

  • thanks Jim, this is a great start. i am going to mark this question as answered, but would love if others could share similar scripts. – SQLRockstar May 28 '09 at 18:02

Not the answer you're looking for? Browse other questions tagged or ask your own question.