Sign up ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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?


locked by HopelessN00b Dec 5 '14 at 11:47

This question exists because it has historical significance, but it is not considered a good, on-topic question for this site, so please do not use it as evidence that you can ask similar questions here. This question and its answers are frozen and cannot be changed. More info: help center.

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

1 Answer 1

up vote 1 down vote accepted

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.