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?
Asked
Active
Viewed 144 times
2
-
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 Answers
1
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
Jim B
- 24,081
- 4
- 36
- 60
-
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