Fast way to check message count
November 9th, 2006A fast way to check the count of messages in a queue is to run this query is to look at the row count of the underlying the b-tree that stores the messages:
select p.rows
from sys.objects as o
join sys.partitions as p on p.object_id = o.object_id
join sys.objects as q on o.parent_object_id = q.object_id
where q.name = ‘<queuename>’
and p.index_id = 1
Read the rest of this entry »
