up vote 2 down vote favorite
share [g+] share [fb]

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?

link|improve this question
75% accept rate
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
feedback

1 Answer

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,
p.SampleValue
FROM Perf.vPerfRaw p
INNER JOIN vManagedEntity me ON me.ManagedEntityRowID =
p.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

link|improve this answer
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
feedback

Your Answer

 
or
required, but never shown
discard

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