Microsoft® SQL Server 2012 Unleashed

Related System Catalogs

A few of the system catalogs and dynamic management views (DMVs) might be of interest to you if you’re debugging Service Broker applications or simply seeking a greater understanding of how Service Broker works under the hood. Let’s take a look at some of them.

You’ve already seen sys.transmission_queue, which is used to store undelivered messages in a particular database. This table is useful because it provides the reason a message is undeliverable (in transmission_status), the date sent (in enqueue_time), a conversation identifier (conversation_handle), contract and service names (service_contract_name, to_service_name, from_service_name), and more.

Another useful catalog is sys.service_queues, which holds the definitions ...