Lazy writes/sec (LazyWritesSec)


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

Property

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


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC PATROL for Microsoft SQL Server 9.6