| title | SQL Server, Broker TO Statistics object | ||||
|---|---|---|---|---|---|
| description | Learn about the SQLServer:Broker TO Statistics performance object, which reports information about Service Broker request transmission objects. | ||||
| author | MikeRayMSFT | ||||
| ms.author | mikeray | ||||
| ms.date | 12/04/2023 | ||||
| ms.service | sql | ||||
| ms.subservice | performance | ||||
| ms.topic | reference | ||||
| helpviewer_keywords |
|
[!INCLUDE SQL Server]
The SQLServer:Broker TO Statistics performance object reports information about how many times [!INCLUDE ssSB] dialogs request transmission objects, and how often transmission objects are written to tempdb.
Transmission objects record the state of message transmissions for a [!INCLUDE ssSB] dialog. They are stored in memory. To free memory, [!INCLUDE ssSB] periodically writes batches of inactive transmission objects to work tables in tempdb.
The following table lists the counters that this object contains.
| SQL Server Broker TO Statistics counters | Description |
|---|---|
| Avg. Length of Batched Writes | The average number of transmission objects saved in a batch. |
| Avg. Time To Write Batch (ms) | The average number of milliseconds required to save a batch of transmission objects. |
| Avg. Time to Write Batch Base | For internal use only. |
| Avg. Time Between Batches (ms) | The average number of milliseconds between writes of transmission object batches. |
| Avg. Time Between Batches Base | For internal use only. |
| Transmission Obj Gets/Sec | The number of times per second that dialogs requested transmission objects. |
| Transmission Obj Set Dirty/Sec | The number of times per second that transmission objects were marked as dirty. Transmission objects are marked as dirty by the first modification that causes the in-memory copy to differ from the copy stored in tempdb. Transmission objects are modified when [!INCLUDE ssSB] has to record a change in the state of message transmissions for the dialog. |
| Transmission Obj Writes/Sec | The number of times per second that a batch of transmission objects were written to tempdb work tables. Large numbers of writes could indicate that [!INCLUDE ssNoVersion] memory is being stressed. |
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 TO Statistics%';