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

Posted by Gabe Brown on Stack Overflow See other posts from Stack Overflow or by Gabe Brown
Published on 2010-05-11T00:18:49Z Indexed on 2010/05/11 0:24 UTC
Read the original article Hit count: 539

Filed under:

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.transmission_queue'
SELECT rows FROM sysindexes WHERE id = OBJECT_ID('ConfigMgrDrsQueue') AND indid < 2

Related posts about service-broker

Service Broker Solutions - Don't Forget the Basics

as seen on SQL Blog - Search for 'SQL Blog'
After finally getting a Service Broker solution implemented successfully, I'm really impressed with the technology, and frustrated how difficult it can be to implement and get it really working as expected. First, understand the technology. There are some great resources out there to help you get… >>> More
Service Broker, not ETL

as seen on SQL Blog - Search for 'SQL Blog'
I have been very quiet on this blog of late and one reason for that is I have been very busy on a client project that I would like to talk about a little here. The client that I have been working for has a website that runs on a distributed architecture utilising a messaging infrastructure for communication… >>> More
Service broker with SqlNotificationRequest

as seen on Stack Overflow - Search for 'Stack Overflow'
I am in the process of evaluating a Service Broker with SQL noticiation for my project. My requirements is User places a order from System A and it will update Order Table. As soon as order is place i need to notify the System B. I have done a quick POC with Trigger , Service Broker and SQLNotificaiton… >>> More
Sql Server Service Broker Conversation Groups

as seen on Stack Overflow - Search for 'Stack Overflow'
Can someone explain conversation groups in service broker? Currently, I'm using service broker to send messages from one SQL server to another. On the sending server, I'm trying to correlate the messages so they are processed in serial on the receiving side. Based on the documentation, conversation… >>> More
Triggers, Service Broker, CDC or Change Tracking?

as seen on SQL Server Planet - Search for 'SQL Server Planet'
When one trigger inserts into a table and that table also contains a trigger, this is a “nested trigger”. The reason that nested triggers are a concern is because the first call that performs the initial insert does not return until the last trigger in sequence is complete. In trying… >>> More

Developer IT

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

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

servicebroker

service-broker

Related posts about servicebroker

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

Service broker with SqlNotificationRequest

CodePlex Daily Summary for Tuesday, February 15, 2011

Related posts about service-broker

Service Broker Solutions - Don't Forget the Basics

Service Broker, not ETL

Service broker with SqlNotificationRequest

Sql Server Service Broker Conversation Groups

Triggers, Service Broker, CDC or Change Tracking?

Categories cloud