MOM 2005 Performance Counters in OnePoint DB Part 1
Ever wonder what performance counters are being captured in the OnePoint Database? This SQL script will shed some light as to what is actually being inserted into the one point database. This script specifically pulls out what has been put into the db for the past two hours using the SDKPerformanceView.
-- Scott Moss 8/1/07
-- Part 1 what Perfmon counters?
-- Get count of performance counters per computer name in onepoint db
-- for the past 2 hours, sorted by number of Performance Counters
select ComputerName, COUNT(*) AS PerformanceCounterCount
from dbo.SDKPerformanceView
where (DateDiff(hh, TimeSampled, GetDate()) <= 2)
GROUP BY ComputerName
ORDER BY PerformanceCounterCount DESC