Skip to content

Latest commit

 

History

History
42 lines (38 loc) · 1.88 KB

File metadata and controls

42 lines (38 loc) · 1.88 KB
title 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.

See Also

Monitor Resource Usage (System Monitor)