sys.dm_broker_forwarded_messages (Transact-SQL)

 

Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns a row for each Service Broker message that an instance of SQL Server is in the process of forwarding.

Column nameData typeDescription
conversation_iduniqueidentifierID of the conversation to which this message belongs. NULLABLE.
is_initiatorbitIndicates whether this message is from the initiator of the conversation. NULLABLE.

0 = Not from initiator

1 = From initiator
to_service_namenvarchar(512)Name of the service to which this message is sent. NULLABLE.
to_broker_instancenvarchar(512)Identifier of the broker that hosts the service to which this message is sent. NULLABLE.
from_service_namenvarchar(512)Name of the service that this message is from. NULLABLE.
from_broker_instancenvarchar(512)Identifier of the broker that hosts the service that this message is from. NULLABLE.
adjacent_broker_addressnvarchar(512)Network address to which this message is being sent. NULLABLE.
message_sequence_numberbigintSequence number of the message in the dialog box. NULLABLE.
message_fragment_numberintIf the dialog message is fragmented, this is the fragment number that this transport message contains. NULLABLE.
hops_remainingtinyintNumber of times the message may be retransmitted before reaching the final destination. Every time the message is forwarded, this number decreases by 1. NULLABLE.
time_to_liveintMaximum time for the message to remain active. When this reaches 0, the message is discarded. NULLABLE.
time_consumedintTime that the message has already been active. Every time the message is forwarded, this number is increased by the time it has taken to forward the message. Not NULLABLE.
message_iduniqueidentifierID of the message. NULLABLE.

Requires VIEW SERVER STATE permission on the server.

Dynamic Management Views and Functions (Transact-SQL)
Service Broker Related Dynamic Management Views (Transact-SQL)

Community Additions

ADD
Show: