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. |
See Also
Other Resources
Service Broker Routing and Networking
Monitoring Resource Usage (System Monitor)