You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
SQL Server, Memory Broker Clerks Object | Microsoft Docs
ms.custom
ms.date
03/01/2017
ms.prod
sql
ms.prod_service
database-engine
ms.service
ms.component
performance-monitor
ms.reviewer
ms.suite
sql
ms.technology
database-engine
ms.tgt_pltfrm
ms.topic
article
helpviewer_keywords
SQLServer:Memory Broker Clerks
ms.assetid
47b9c236-66a3-4c42-97ee-da5555bdc046
caps.latest.revision
4
author
dagiro
ms.author
v-dagir
manager
craigg
ms.workload
Inactive
SQL Server, Memory Broker Clerks Object
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]
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.