开发者

How do I get the size of a Service Broker Queue quickly when the table is >500k rows?

开发者 https://www.devze.com 2022-12-29 16:38 出处:网络
I\'m trying to determine the total size of a Service Broker Queue and transmission queue when the queue is very large.The problem is traditional querys like the ones below don\'t work since it\'s not

I'm trying to determine the total size of a Service Broker Queue and transmission queue when the queue is very large. The problem is traditional querys like the ones below don't work since it's not a table. Any ideas?

EXEC sp_spaceused 'sys.transmissio开发者_运维知识库n_queue'
SELECT rows FROM sysindexes WHERE id = OBJECT_ID('ConfigMgrDrsQueue') AND indid < 2  


Remus explains explains how to do it in his blog. Basically you need to query the row count of the underlying b-tree.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号