N-central Help

SQL Server Buffer Manager service

The SQL Server Buffer Manager service monitors how an SQL Server uses memory to store data pages, the physical Input/Output as SQL Server reads and writes database pages, and the buffer cache by using fast non-volatile storage such as solid-state drives (SSD).

Service Type WMI
Instances on a Device 15
Supported Systems/Applications Microsoft SQL Server
Device Class Server - Generic, Workstation - Generic, Other, Printer, Scanner/Camera, Switch/Router, Laptop - Windows, Server - Windows, and Workstation - Windows
Monitored By Windows agent
Scan Interval 15 minutes
SQL Server Instance The specific instance of the SQL Server database engine running on the target server.

 

Status Detail Description
Buffer Cache Hit Ratio The percentage of pages found in the buffer cache without having to be read from a disk.
Page Reads Per Second The number of physical database page reads that are issued per second.
Page Writes Per Second The number of physical database page writes that are issued per second.
Page Life Expectancy (sec) The number of seconds that a page will stay in the buffer pool without references.
Lazy Writes Per Second The number of buffers written per second by the buffer manager's lazy writer. The lazy writer is a system process that flushes out batches of dirty, aged buffers -buffers that contain changes that must be written back to disk before the buffer can be reused for a different page - and makes them available to user processes. The lazy writer eliminates the need to perform frequent checkpoints in order to create available buffers.