SQL Server:Buffer Node

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

The Buffer Node object provides counters that complement counters provided by the Buffer Manager object. It allows you to monitor the SQL Server buffer pool page distribution for each non-uniform memory access (NUMA) node. There is an instance of the Buffer Node object for each NUMA node in use. On non-NUMA architecture, there will be a single instance of the Buffer Node object.

Buffer Node Performance Objects

This table describes the SQL Server Buffer Node performance objects.

SQL Server Buffer Node counters Description
Database pages Indicates the number of pages in the buffer pool on this node with database content.
Page life expectancy Indicates the minimum number of seconds a page will stay in the buffer pool on this node without references.
Local Node page lookups/sec Indicates the number of lookup requests from this node which were satisfied from this node.
Remote Note page lookups/sec Indicates the number of lookup requests from this node which were satisfied from other nodes.

If SQL Server is running on non-NUMA hardware, the counters of Buffer Node and Buffer Manager objects should match.

On NUMA hardware, sums of respective counters of all Buffer Nodes should match their counterparts of Buffer Manager.

Note

The counter values and sums may not match precisely due to the dynamic nature of the counters and the sampling accuracy.

See Also

SQL Server, Buffer Manager Object
Server Memory Server Configuration Options
Monitor Resource Usage (System Monitor)
sys.dm_os_performance_counters (Transact-SQL)