I wrote a customer a report a while back – I haven’t blogged about it yet – but here is the foundation query for it:

select Path, ObjectName, CounterName, SampleValue, DateTime

from Perf.vPerfRaw pvpr

inner join vManagedEntity vme on pvpr.ManagedEntityRowId = vme.ManagedEntityRowId

inner join vPerformanceRuleInstance vpri on pvpr.PerformanceRuleInstanceRowId = vpri.PerformanceRuleInstanceRowId

inner join vPerformanceRule vpr on vpr.RuleRowId = vpri.RuleRowId

A couple notes:

Raw perf data was not designed to be queried in the warehouse.  We only keep 10 days by default – and while some customers do bump this up, we generally don’t recommend it.  Also – there are no good indexes built on the raw data for common fields – so query performance will stink.  Also – complex queries that hold locks will impact the ability for the warehouse maintenance tasks to perform.

Understanding all that – knock yerself out.

In OperationsManager, look in the PerformanceDataAllView view.  In OperationsManagerDW, look in the vPerfRaw view.  You’ll have to join views to make the data meaningful, but will get you much of the raw data from those locations.

-Mike

Is there a way to get a raw data out of SCOM R2? We have a user who is trying to get access to the raw data instead of the graphs. Thank you.

==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/momlist/

==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/momlist/

==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/momlist/