Top 50 performance sample inserts for last 10 days (by default)
/*Top 50 Performance Sample Inserts for last 10 days by default.*/
USE OperationsManagerDW
SELECT TOP (50) COUNT(*) AS Count, vPerformanceRule.ObjectName AS Object, vPerformanceRule.CounterName AS Counter,
vPerformanceRuleInstance.InstanceName AS Instance, vRule.RuleDefaultName AS 'Collection Rule',
vManagementPack.ManagementPackDefaultName AS 'Management Pack'
FROM Perf.vPerfRaw INNER JOIN
vPerformanceRuleInstance ON Perf.vPerfRaw.PerformanceRuleInstanceRowId = vPerformanceRuleInstance.PerformanceRuleInstanceRowId INNER JOIN
vPerformanceRule ON vPerformanceRuleInstance.RuleRowId = vPerformanceRule.RuleRowId INNER JOIN
vRule ON vPerformanceRule.RuleRowId = vRule.RuleRowId INNER JOIN
vManagementPack ON vRule.ManagementPackRowId = vManagementPack.ManagementPackRowId
GROUP BY vPerformanceRule.ObjectName, vPerformanceRule.CounterName, vPerformanceRuleInstance.InstanceName, vRule.RuleDefaultName,
vManagementPack.ManagementPackDefaultName
ORDER BY Count DESC