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)

Concepts

SQL Server Service Broker

Monitor Resource Usage (System Monitor)