Lazy writes/sec (LazyWritesSec) - Documentation for BMC PATROL for Microsoft SQL Server 9.6
Indicates 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
BMC PATROL properties
Property | Default value |
|---|---|
Application class | MSSQL_SERVER_PERFMON_BUFFER_MANAGER |
Command type | NA |
Platform | All |
Icon style | Graph |
Unit | Per sec |
Border range | Undefined |
Alarm1 range | Undefined |
Alarm2 range | Undefined |
Scheduling (poll time) | Inherited |
Active at installation | Yes |
Parameter type | Consumer |
TrueSight/ BMC Helix Operations Management properties
Default value | |
|---|---|
| Monitor type | MS SQL Server Perfmon Buffer Manager |
Key Performance Indicator | No |
| Monitor for abnormalities | No |
| Graph by default | No |
| Availability | No |
| Response time | No |
| Normal distribution | No |
| Statistical | No |
