sys.dm_broker_forwarded_messages (Transact-SQL)
Applies to: 
SQL Server
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.
Permissions for SQL Server 2022 and later
Requires VIEW SERVER PERFORMANCE STATE permission on the server.
See also
Dynamic Management Views and Functions (Transact-SQL)
Service Broker Related Dynamic Management Views (Transact-SQL)