Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate SQL, Power BI, Fabric, and AI community-led event. March 31 - April 2. Use code MSCUST for a $150 discount. Prices go up Feb 11th.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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. |
Requires VIEW SERVER STATE permission on the server.
Requires VIEW SERVER PERFORMANCE STATE permission on the server.
Dynamic Management Views and Functions (Transact-SQL)
Service Broker Related Dynamic Management Views (Transact-SQL)
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate SQL, Power BI, Fabric, and AI community-led event. March 31 - April 2. Use code MSCUST for a $150 discount. Prices go up Feb 11th.
Register today