| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | ||
|---|---|---|---|---|---|---|---|---|---|---|
SQL Server, Broker Statistics object |
Learn about the SQLServer:Broker Statistics performance object, which contains performance counters that report Service Broker information for Database Engine. |
MikeRayMSFT |
mikeray |
12/04/2023 |
sql |
performance |
reference |
|
[!INCLUDE SQL Server]
The SQLServer:Broker Statistics performance object contains performance counters that report general [!INCLUDE ssSB] information for an instance of the [!INCLUDE ssDE]. The following table lists the counters that this object contains:
| SQL Server Broker Statistics counters | Description |
|---|---|
| Activation Errors Total | The number of times a [!INCLUDE ssSB] activation stored procedure exited with an error. |
| Broker Transaction Rollbacks | The number of rolled-back transactions that contained DML statements related to [!INCLUDE ssSB], 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 [!INCLUDE ssSB] 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 from local endpoints and the transport that are successfully delivered into local target queues per second, including messages of all priority levels. |
| Enqueued P1 Msgs/sec | The number of priority 1 messages from local endpoints and the transport that are successfully delivered into local target queues, per second. |
| Enqueued P2 Msgs/sec | The number of priority 2 messages from local endpoints and the transport that are successfully delivered into local target queues, per second. |
| Enqueued P3 Msgs/sec | The number of priority 3 messages from local endpoints and the transport that are successfully delivered into local target queues, per second. |
| Enqueued P4 Msgs/sec | The number of priority 4 messages from local endpoints and the transport that are successfully delivered into local target queues, per second. |
| Enqueued P5 Msgs/sec | The number of priority 5 messages from local endpoints and the transport that are successfully delivered into local target queues, per second. |
| Enqueued P6 Msgs/sec | The number of priority 6 messages from local endpoints and the transport that are successfully delivered into local target queues, per second. |
| Enqueued P7 Msgs/sec | The number of priority 7 messages from local endpoints and the transport that are successfully delivered into local target queues, per second. |
| Enqueued P8 Msgs/sec | The number of priority 8 messages from local endpoints and the transport that are successfully delivered into local target queues, per second. |
| Enqueued P9 Msgs/sec | The number of priority 9 messages from local endpoints and the transport that are successfully delivered into local target queues, per second. |
| Enqueued P10 Msgs/sec | The number of priority 10 messages from local endpoints and the transport that are successfully delivered into local target queues, per second. |
| Enqueued Transmission Msgs/sec | The number of messages that have been placed in the [!INCLUDE ssSB] 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 [!INCLUDE ssSB] 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 [!INCLUDE tsql] RECEIVE statements processed by the Broker. |
| SQL RECEIVEs/sec | The number of [!INCLUDE tsql] RECEIVE statements processed by the Broker per second. |
| SQL SEND Total | The total number of [!INCLUDE tsql] SEND statements executed. |
| SQL SENDs/sec | The number of [!INCLUDE tsql] SEND statements executed per second. |
You begin to explore the query performance counters in this object using this T-SQL query on the sys.dm_os_performance_counters dynamic management view:
SELECT * FROM sys.dm_os_performance_counters
WHERE object_name LIKE '%Broker Statistics%';