SQL Server, Memory Broker Clerks Object

THIS TOPIC APPLIES TO: yesSQL ServernoAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

The SQLServer:Memory Broker Clerks performance object provides counters for statistics related to memory broker clerks.

This following table describes the SQL Server Memory Broker Clerks performance objects.

SQL Server Memory Broker Clerks counters Description
Internal benefit The internal value of memory for entry count pressure, in ms per page per ms, multiplied by 10 billion and truncated to an integer.
Memory broker clerk size The size of the the clerk, in pages.
Periodic evictions (pages) The number of pages evicted from the broker clerk by last periodic eviction.
Pressure evictions (pages/sec) TThe number of pages per second evicted from the broker clerk by memory pressure.
Simulation benefit The value of memory to the clerk, in ms per page per ms, multiplied by 10 billion and truncated to an integer.
Simulation size The current size of the clerk simulation, in pages.

There is an instance of the counter for the buffer pool, and the column store object pool.

See Also

Monitor Resource Usage (System Monitor)