SQL Server, Broker / DBM Transport Object
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 counter |
Description |
|---|---|
Current Bytes for Recv I/O |
This counter reports the number of bytes to be read by the currently running transport receive operations. |
Current Bytes for Send I/O |
This 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/O |
This counter reports the total number of message fragments that are in the process of being sent over the network. |
Message Fragment P1 Sends/sec |
This counter reports the number of priority 1 message fragments sent over the network per second. |
Message Fragment P2 Sends/sec |
This counter reports the number of priority 2 message fragments sent over the network per second. |
Message Fragment P3 Sends/sec |
This counter reports the number of priority 3 message fragments sent over the network per second. |
Message Fragment P4 Sends/sec |
This counter reports the number of priority 4 message fragments sent over the network per second. |
Message Fragment P5 Sends/sec |
This counter reports the number of priority 5 message fragments sent over the network per second. |
Message Fragment P6 Sends/sec |
This counter reports the number of priority 6 message fragments sent over the network per second. |
Message Fragment P7 Sends/sec |
This counter reports the number of priority 7 message fragments sent over the network per second. |
Message Fragment P8 Sends/sec |
This counter reports the number of priority 8 message fragments sent over the network per second. |
Message Fragment P9 Sends/sec |
This counter reports the number of priority 9 message fragments sent over the network per second. |
Message Fragment P10 Sends/sec |
This counter reports the number of priority 10 message fragments sent over the network per second. |
Message Fragment Send Size Avg |
This counter reports the average size of the message fragments sent over the network. |
Message Fragment Sends/sec |
This counter reports the number of message fragments of all priorities sent over the network per second. |
Msg Fragment Receives/sec |
This counter reports the number of message fragments received over the network per second. |
Msg Fragment Recv Size Avg |
This counter reports the average size of message fragments received over the network. |
Open Connection Count |
This counter reports the number of network connections that Service Broker currently has open. |
Pending Bytes for Recv I/O |
This 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/O |
This 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/O |
This 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/O |
This counter reports the total number of message fragments that are ready to be sent over the network. |
Receive I/O Bytes Total |
This counter reports the total number of bytes received over the network by Service Broker endpoints and Database Mirroring endpoints. |
Receive I/O bytes/sec |
This counter reports the number of bytes per second received over the network by Service Broker endpoints and Database Mirroring endpoints. |
Receive I/O Len Avg |
This counter reports the average number of bytes for a transport receive operation. |
Receive I/Os/second |
This 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 Total |
This counter reports the total number of bytes sent over the network by Service Broker endpoints and Database Mirroring endpoints. |
Send I/O bytes/sec |
This counter reports the number of bytes per second sent over the network by Service Broker endpoints and Database Mirroring endpoints. |
Send I/O Len Avg |
This 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/sec |
This 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. |
See Also
Reference
sys.dm_broker_forwarded_messages (Transact-SQL)