SQL Server, Broker TO Statistics Object
Applies To: SQL Server 2016
The SQLServer:Broker TO Statistics performance object reports information about how many times Service Broker dialogs request transmission objects, and how often transmission objects are written to tempdb.
Transmission objects record the state of message transmissions for a Service Broker dialog. They are stored in memory. To free memory, Service Broker 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.|
|Tran Object Gets/sec||The number of times per second that dialogs requested transmission objects.|
|Tran Objects Marked 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 Service Broker has to record a change in the state of message transmissions for the dialog.|
|Tran Object 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 SQL Server memory is being stressed.|