Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
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 clerk, in pages. |
| Periodic evictions (pages) | The number of pages evicted from the broker clerk by last periodic eviction. |
| Pressure evictions (pages/sec) | The 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 columnstore object pool.
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 '%Memory Broker Clerks%';