Friday, March 23, 2012

Performance Counters on Service Broker Transmission Queue

Hello,

is there built-in support for monitoring the number of elements in the transmission queue via performance counters?

Thanks,

There's no perfmon counter. Something like count () or sp_spaceused would be required to query the count. The message send perfmon counters probably are a better indication of what's happening at the connection level - depending on what you're trying to measure.|||

No performance counter. See this post for an efficient query to return the number of rows in the hidden table that represents the transmission queue: http://blogs.msdn.com/remusrusanu/archive/2006/11/08/fast-way-to-check-message-count.aspx

HTH,
~ Remus

|||Thank you both

No comments:

Post a Comment