Fast way to check message count

November 9th, 2006

A 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 = ‘<queuename>’

and p.index_id = 1

Read the rest of this entry »