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.