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.

See Also

Reference

Dynamic Management Views and Functions (Transact-SQL)

Service Broker Related Dynamic Management Views (Transact-SQL)