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. |