MOM 2005 Performance Counters in OnePoint DB - Part 2
After using the script in part one, you notice a server that is dumping a large number of performance counters into the OnePoint database, use this script to figure out what entries its adding to the OnePoint database. This script will output the Performance Counters for one server that you specify for the past two hours sorted by the sampled time.
-- Scott Moss
-- Part 2 what Perfmon counters?
-- Get performance Counters for a single server for the past 2 hours
-- from the onepoint database.
Declare @Server varchar(30)
SET @Server = 'YOURSERVERNAMEHERE' -- a server name
select ComputerName, PerformanceInstanceName, PerformanceObjectName, PerformanceCounterName,
TimeSampled, SampledValue
from dbo.SDKPerformanceView
where (DateDiff(hh, TimeSampled, GetDate()) <= 2) AND ComputerName=@Server
Order by TimeSampled ASC -- END SQL SCRIPT