Microsoft® SQL Server® 2012 Bible

658

Part V: Enterprise Data Management

Catalog View Description

sys.service_contract_usages This catalog view contains a row per (service, con-

tract) pair.

sys.service_message_types This catalog view contains a row per message type

registered in the service broker.

sys.service_queue_usages This catalog view returns a row for each reference

between service and service queue. A service can

only be associated with one queue. A queue can be

associated with multiple services.

sys.services This catalog view contains a row for each service in

the database.

sys.transmission_queue This catalog view contains a row for each message in

the transmission queue.

For a detailed description of each of these catalog views, refer to http://msdn

.microsoft.com/en-us/library/ms173780.aspx.

Table 25-3 describes the Service Broker Dynamic Management Views available for SQL

Server 2012.

TABLE 25 -3 Service Broker Dynamic Management Views

DMV Description

sys.dm_broker_activated_tasks Returns a row for each stored procedure activated by

Service Broker

sys.dm_broker_forwarded_messages Returns a row for each Service Broker message that an

instance of SQL Server is in the process of forwarding

sys.dm_broker_connections Returns a row for each Service Broker network

connection

sys.dm_broker_queue_monitors Returns a row for each queue monitor in the instance

For a detailed description of each of these DMVs refer to http://msdn.microsoft.com/

en-us/library/ms176110.aspx.

As an alternative you can also query the queues directly using T-SQL. You can browse the

different queues available using SQL Server Management Studio by expanding Service

Broker ➪ Queues.

TABLE 25 -2 (continued)

c25.indd 658c25.indd 658 7/31/2012 9:21:38 AM7/31/2012 9:21:38 AM

http://www.it-ebooks.info