SQL Server, Broker Statistics Object
The SQLServer:Broker Statistics performance object contains performance counters that report general Service Broker information for an instance of the Database Engine. The following table lists the counters that this object contains:
| SQL Server Broker Statistics counters | Description |
|---|---|
| Activation Errors Total | The number of times a Service Broker activation stored procedure exited with an error. |
| Broker Transaction Rollbacks | The number of rolled-back transactions that contained DML statements related to Service Broker, such as SEND and RECEIVE. |
| Corrupted Messages Total | The number of corrupted messages that were received by the instance. |
| Dequeued Transmission Msgs/sec | The number of messages that have been removed from the Service Broker transmission queue per second. |
| Dialog timer event count | The number of timers active in the dialog protocol layer. This number corresponds to the number of active dialogs. |
| Dropped Messages Total | The number of messages that were received by the instance, but could not be delivered to a queue. |
| Enqueued Local Messages Total | The number of messages that have been put into 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 put into 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 put into the queues in the instance. |
| Enqueued Messages/sec | The number of messages per second that have been put into the queues in the instance. This includes messages of all priority levels. |
| Enqueued P1 Msgs/sec | The number of priority 1 messages per second that have been put into the queues in the instance. |
| Enqueued P2 Msgs/sec | The number of priority 2 messages per second that have been put into the queues in the instance. |
| Enqueued P3 Msgs/sec | The number of priority 3 messages per second that have been put into the queues in the instance. |
| Enqueued P4 Msgs/sec | The number of priority 4 messages per second that have been put into the queues in the instance. |
| Enqueued P5 Msgs/sec | The number of priority 5 messages per second that have been put into the queues in the instance. |
| Enqueued P6 Msgs/sec | The number of priority 6 messages per second that have been put into the queues in the instance. |
| Enqueued P7 Msgs/sec | The number of priority 7 messages per second that have been put into the queues in the instance. |
| Enqueued P8 Msgs/sec | The number of priority 8 messages per second that have been put into the queues in the instance. |
| Enqueued P9 Msgs/sec | The number of priority 9 messages per second that have been put into the queues in the instance. |
| Enqueued P10 Msgs/sec | The number of priority 10 messages per second that have been put into the queues in the instance. |
| Enqueued Transmission Msgs/sec | The number of messages that have been placed in the Service Broker transmission queue per second. |
| Enqueued Transport Msg Frag Tot | The number of message fragments that have been put into 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 put into the queues in the instance. |
| Enqueued Transport Msgs Total | The number of messages that have been put into 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 put into 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
SQL Server Service Broker
Monitor Resource Usage (System Monitor)