0
votes

I have a number of custom SQL Server Service Broker queues. The messages from the queues are processed by stored procedures (both T-SQL and CLR). I want to monitor the throughput of each processor per queue, i.e. how many queue messages were processed per minute in the given SSB queue.

1

1 Answers

0
votes

If you have one procedure per queue, take a look at sys.dm_exec_procedure_stats and note the number of executions. Take periodic snapshots diff them and that should give you what you need.