Export (0) Print
Expand All

SQL Server, Broker Statistics Object

The SQLServer:Broker Statistics performance object contains performance counters that report general Service Broker information. The table below lists the counters that this object contains.

SQL Server Broker Statistics counters Description

Broker Transaction Rollbacks

The number of rolled back transactions that contained DML-related to Service Broker.

Dialog timer event count

The number of timers active in the dialog protocol layer. This number corresponds to the number of active dialogs.

Enqueued Local Messages Total

The number of messages that have been placed onto the queues in the instance, counting only messages that did not arrive through the network.

Enqueued Local Messages/sec

The number of messages per second that have been placed onto the queues in the instance, counting only messages that did not arrive through the network.

Enqueued Messages Total

The total number of messages that have been placed onto the queues in the instance.

Enqueued Messages/sec

The number of messages per second that have been placed onto the queues in the instance.

Enqueued Transport Msg Frag Tot

The number of message fragments that have been placed onto the queues in the instance, counting only messages that arrived through the network.

Enqueued Transport Msg Frags/sec

The number of message fragments per second that have been placed onto the queues in the instance.

Enqueued Transport Msgs Total

The number of messages that have been placed onto the queues in the instance, counting only messages that arrived through the network.

Enqueued Transport Msgs/sec

The number of messages per second that have been placed onto the queues in the instance, counting only messages that arrived through the network.

Forwarded Messages Total

The total number of Service Broker messages forwarded by this computer.

Forwarded Messages/sec

The number of messages per second forwarded by this computer.

Forwarded Msg Byte Total

The total size, in bytes, of the messages forwarded by this computer.

Forwarded Msg Bytes/sec

The size, in bytes, of messages per second forwarded by this computer.

Forwarded Msg Discarded Total

The number of messages that this computer received for forwarding, but did not successfully forward.

Forwarded Msg Discarded/sec

The number of messages per second that this computer received for forwarding, but did not successfully forward.

Forwarded Pending Msg Bytes

The total size of the messages currently held for forwarding.

Forwarded Pending Msg Count

The total number of messages currently held for forwarding.

SQL RECEIVE Total

The total number of Transact-SQL RECEIVE statements processed.

SQL RECEIVEs/sec

The number of Transact-SQL RECEIVE statements processed per second.

SQL SEND Total

The total number of Transact-SQL SEND statements executed.

SQL SENDs/sec

The number of Transact-SQL SEND statements executed per second.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft