नोट
इस पेज तक पहुँच के लिए प्रमाणन की आवश्यकता होती है. आप साइन इन करने या निर्देशिकाओं को बदलने का प्रयास कर सकते हैं.
इस पेज तक पहुँच के लिए प्रमाणन की आवश्यकता होती है. आप निर्देशिकाओं को बदलने का प्रयास कर सकते हैं.
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)