Редагувати

Поділитися через


SQL Server, Broker TO Statistics object

Applies to: SQL Server

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.
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 Service Broker 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 SQL Server memory is being stressed.

Example

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%';