TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

SQL Server, Broker - DBM Transport Object

 

Applies To: SQL Server 2016

The Broker / DBM Transport performance object contains performance counters that report networking information for Service Broker and database mirroring. The table below lists the counters that this object contains.

SQL Server Broker / DBM Transport counterDescription
Current Bytes for Recv I/OThis counter reports the number of bytes to be read by the currently running transport receive operations.
Current Bytes for Send I/OThis counter reports the number of bytes in message fragments that are currently in the process of being sent over the network.
Current Msg Frags for Send I/OThis counter reports the total number of message fragments that are in the process of being sent over the network.
Message Fragment P1 Sends/secThis counter reports the number of priority 1 message fragments sent over the network per second.
Message Fragment P2 Sends/secThis counter reports the number of priority 2 message fragments sent over the network per second.
Message Fragment P3 Sends/secThis counter reports the number of priority 3 message fragments sent over the network per second.
Message Fragment P4 Sends/secThis counter reports the number of priority 4 message fragments sent over the network per second.
Message Fragment P5 Sends/secThis counter reports the number of priority 5 message fragments sent over the network per second.
Message Fragment P6 Sends/secThis counter reports the number of priority 6 message fragments sent over the network per second.
Message Fragment P7 Sends/secThis counter reports the number of priority 7 message fragments sent over the network per second.
Message Fragment P8 Sends/secThis counter reports the number of priority 8 message fragments sent over the network per second.
Message Fragment P9 Sends/secThis counter reports the number of priority 9 message fragments sent over the network per second.
Message Fragment P10 Sends/secThis counter reports the number of priority 10 message fragments sent over the network per second.
Message Fragment Send Size AvgThis counter reports the average size of the message fragments sent over the network.
Message Fragment Sends/secThis counter reports the number of message fragments of all priorities sent over the network per second.
Msg Fragment Receives/secThis counter reports the number of message fragments received over the network per second.
Msg Fragment Recv Size AvgThis counter reports the average size of message fragments received over the network.
Open Connection CountThis counter reports the number of network connections that Service Broker currently has open.
Pending Bytes for Recv I/OThis counter reports the number of bytes contained in message fragments that have been received from the network but have not yet been placed on a queue or discarded.
Pending Bytes for Send I/OThis counter reports the total number of bytes in message fragments that are ready to be sent over the network.
Pending Msg Frags for Recv I/OThis counter reports the number of message fragments that have been received from the network, but that have not yet been placed on a queue or discarded.
Pending Msg Frags for Send I/OThis counter reports the total number of message fragments that are ready to be sent over the network.
Receive I/O Bytes TotalThis counter reports the total number of bytes received over the network by Service Broker endpoints and Database Mirroring endpoints.
Receive I/O bytes/secThis counter reports the number of bytes per second received over the network by Service Broker endpoints and Database Mirroring endpoints.
Receive I/O Len AvgThis counter reports the average number of bytes for a transport receive operation.
Receive I/Os/secondThis counter reports the number of transport receive I/O operations per second that the Service Broker / DBM transport layer has completed. Notice that a transport receive operation may contain more than one message fragment.
Send I/O Bytes TotalThis counter reports the total number of bytes sent over the network by Service Broker endpoints and Database Mirroring endpoints.
Send I/O bytes/secThis counter reports the number of bytes per second sent over the network by Service Broker endpoints and Database Mirroring endpoints.
Send I/O Len AvgThis counter reports the average size in bytes of each transport send operation. Notice that a transport send operation may contain more than one message fragment.
Send I/Os/secThis counter reports the number of transport send I/O operations per second that have completed. Notice that a transport send operation may contain more than one message fragment.

sys.dm_broker_forwarded_messages (Transact-SQL)
SQL Server Service Broker
Monitor Resource Usage (System Monitor)

Community Additions

ADD
Show:
© 2016 Microsoft