If you want to monitor the messages that are currently being forwarded to the message
forwarder, Service Broker provides this information through the sys.dm_broker_forwarded_
messages catalog view. Table 11-3 shows the columns of this view.

Column Data Type Description
Column : conversation_id
Data Type : UNIQUEIDENTIFIER
Description : Stores the conversation ID to which the forwarded message belongs.

is_initiator
BIT
Indicates if the message is associated with the initiator of the conversation.

to_service_name
NVARCHAR(512)
The name of the service to which the message is forwarded.

to_broker_instance
NVARCHAR(512)
The instance GUID of the service to which the message is forwarded.

from_service_name
NVARCHAR(512)
The name of the service from which the message is received.

from_broker_instance
NVARCHAR(512)
The instance GUID of the service from which the message is received.

adjacent_broker_address
NVARCHAR(512)
The network address to which the message is forwarded.

message_sequence_number
BIGINT
Stores the sequence number of themessage.

message_fragment_number
INT
When the received message is fragmented, this column stores the current fragment number of the message.

hops_remaining
TINYINT
Stores the number of the remaining forwarders until the messages reach their final destination—the target service.

time_to_live
INT
Indicates the amount of time until the message is invalid and discarded. In this case, the message must be resent.

time_consumed
INT
Indicates the amount of time the message is alive. Every time the message is forwarded, this amount of time is increased by the time it has taken to forward the message.

message_id
UNIQUEIDENTIFIER
Stores the ID of the forwarded message.

Source of Information: Apress Pro SQL Server 2008 Service Broker

0 comments


Subscribe to Developer Techno ?
Enter your email address:

Delivered by FeedBurner