sys.dm_broker_forwarded_messages (Transact-SQL)
Returns a row for each Service Broker message that an instance of SQL Server is in the process of forwarding.
Column name |
Data type |
Description |
|---|---|---|
conversation_id |
uniqueidentifier |
ID of the conversation to which this message belongs. NULLABLE. |
is_initiator |
bit |
Indicates whether this message is from the initiator of the conversation. NULLABLE. 0 = Not from initiator 1 = From initiator |
to_service_name |
nvarchar(512) |
Name of the service to which this message is sent. NULLABLE. |
to_broker_instance |
nvarchar(512) |
Identifier of the broker that hosts the service to which this message is sent. NULLABLE. |
from_service_name |
nvarchar(512) |
Name of the service that this message is from. NULLABLE. |
from_broker_instance |
nvarchar(512) |
Identifier of the broker that hosts the service that this message is from. NULLABLE. |
adjacent_broker_address |
nvarchar(512) |
Network address to which this message is being sent. NULLABLE. |
message_sequence_number |
bigint |
Sequence number of the message in the dialog box. NULLABLE. |
message_fragment_number |
int |
If the dialog message is fragmented, this is the fragment number that this transport message contains. NULLABLE. |
hops_remaining |
tinyint |
Number 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_live |
int |
Maximum time for the message to remain active. When this reaches 0, the message is discarded. NULLABLE. |
time_consumed |
int |
Time 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_id |
uniqueidentifier |
ID of the message. NULLABLE. |
Permissions
Requires VIEW SERVER STATE permission on the server.