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 (
from_service_name), and more.
Another useful catalog is
sys.service_queues, which holds the definitions ...