SELECT qm.database_id, qm.queue_id, q.[name] AS queue_name, qm.STATE, qm.last_empty_rowset_time, qm.last_activated_time, qm.tasks_waiting FROM sys.dm_broker_queue_monitors qm JOIN sys.[service_queues] q ON q.[object_id] = qm.[queue_id]; SELECT * FROM sys.dm_os_performance_counters WHERE object_name LIKE '%Broker Statistics%' AND [counter_name] IN ( 'Corrupted Messages Total', 'Activation Errors Total', 'Dropped Messages Total', 'Enqueued Local Messages Total','Enqueued Transport Msgs Total', 'Forwarded Messages Total' );