TechNet
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 for an instance of the Database Engine. The following table lists the counters that this object contains:

SQL Server Broker Statistics countersDescription
Activation Errors TotalThe number of times a Service Broker activation stored procedure exited with an error.
Broker Transaction RollbacksThe number of rolled-back transactions that contained DML statements related to Service Broker, such as SEND and RECEIVE.
Corrupted Messages TotalThe number of corrupted messages that were received by the instance.
Dequeued Transmission Msgs/secThe number of messages that have been removed from the Service Broker transmission queue per second.
Dialog timer event countThe number of timers active in the dialog protocol layer. This number corresponds to the number of active dialogs.
Dropped Messages TotalThe number of messages that were received by the instance, but could not be delivered to a queue.
Enqueued Local Messages TotalThe 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/secThe 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 TotalThe total number of messages that have been put into the queues in the instance.
Enqueued Messages/secThe 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/secThe number of priority 1 messages per second that have been put into the queues in the instance.
Enqueued P2 Msgs/secThe number of priority 2 messages per second that have been put into the queues in the instance.
Enqueued P3 Msgs/secThe number of priority 3 messages per second that have been put into the queues in the instance.
Enqueued P4 Msgs/secThe number of priority 4 messages per second that have been put into the queues in the instance.
Enqueued P5 Msgs/secThe number of priority 5 messages per second that have been put into the queues in the instance.
Enqueued P6 Msgs/secThe number of priority 6 messages per second that have been put into the queues in the instance.
Enqueued P7 Msgs/secThe number of priority 7 messages per second that have been put into the queues in the instance.
Enqueued P8 Msgs/secThe number of priority 8 messages per second that have been put into the queues in the instance.
Enqueued P9 Msgs/secThe number of priority 9 messages per second that have been put into the queues in the instance.
Enqueued P10 Msgs/secThe number of priority 10 messages per second that have been put into the queues in the instance.
Enqueued Transmission Msgs/secThe number of messages that have been placed in the Service Broker transmission queue per second.
Enqueued Transport Msg Frag TotThe 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/secThe number of message fragments per second that have been put into the queues in the instance.
Enqueued Transport Msgs TotalThe number of messages that have been put into the queues in the instance, counting only messages that arrived through the network.
Enqueued Transport Msgs/secThe 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 TotalThe total number of Service Broker messages forwarded by this computer.
Forwarded Messages/secThe number of messages per second forwarded by this computer.
Forwarded Msg Byte TotalThe total size, in bytes, of the messages forwarded by this computer.
Forwarded Msg Bytes/secThe size, in bytes, of messages per second forwarded by this computer.
Forwarded Msg Discarded TotalThe number of messages that this computer received for forwarding, but did not successfully forward.
Forwarded Msg Discarded/secThe number of messages per second that this computer received for forwarding, but did not successfully forward.
Forwarded Pending Msg BytesThe total size of the messages currently held for forwarding.
Forwarded Pending Msg CountThe total number of messages currently held for forwarding.
SQL RECEIVE TotalThe total number of Transact-SQL RECEIVE statements processed.
SQL RECEIVEs/secThe number of Transact-SQL RECEIVE statements processed per second.
SQL SEND TotalThe total number of Transact-SQL SEND statements executed.
SQL SENDs/secThe number of Transact-SQL SEND statements executed per second.

SQL Server Service Broker
Monitor Resource Usage (System Monitor)

Show:
© 2016 Microsoft