/*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

Back to SQL queries main menu