MOM 2005 reporting help

[MEC01]

Can someone help please fairly new to SQL and MOM and need an SQL script to extract performance data information. Need to be able to extract for a speficed server or server group one counter select a counter within a data range using SQL not the reporting system.

Just trying to learn the tables or view that are hit during the query.

Using the reporting system for 2005 SystemCentre database

Would appreciate any help

 

[vrcs]

Try performance monitor disk and queue read write I/O benchmarks or some SQL DBCC query analyzer scripts, I wasn't to impressed about the MOM 2005 sql reports