Getting the 100 biggest Agent Queues out of your Operations Manager Database +
Getting a decent overview of you Operations Manager Agents sometimes is a bit hard. There’s a nice graph to display the “Send Queue % Usage” but you have to click through every agent status to find the interesting ones. Most likely the ones with a high percentage status.
Another way, although with less current data would be to query your Data Warehouse with the following statement
SELECT TOP (100) vManagedEntity.Path,
vPerformanceRule.CounterName,
Perf.vPerfHourly.DateTime,
Perf.vPerfHourly.AverageValue AS Avg,
Perf.vPerfHourly.MinValue AS Min,
Perf.vPerfHourly.MaxValue AS Max
FROM Perf.vPerfHourly
INNER JOIN vManagedEntity ON Perf.vPerfHourly.ManagedEntityRowId = vManagedEntity.ManagedEntityRowId
INNER JOIN vPerformanceRuleInstance ON Perf.vPerfHourly.PerformanceRuleInstanceRowId = vPerformanceRuleInstance.PerformanceRuleInstanceRowId
INNER JOIN vPerformanceRule ON vPerformanceRuleInstance.RuleRowId = vPerformanceRule.RuleRowId
WHERE (vPerformanceRule.CounterName LIKE N'%send queue % used')
ORDER BY Perf.vPerfHourly.DateTime DESC,
Avg DESC
This query returns the 100 Queue with the highest fill rate. Note, that data in the Data Warehouse DB can be several hours behind the Operations Database.