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. |