Take the 2-minute tour ×
Server Fault is a question and answer site for professional 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?

share|improve this question
    
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
add comment

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

share|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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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