Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Monitoring and improving database performance » Improving database performance » Performance Monitor statistics

 

Disk write statistics

These statistics describe the amount and type of activity devoted to writing information to disk.

Statistic Scope Description
Disk Writes: Active Database Shows the current number of file writes issued by the database server that aren't yet completed.
Disk Writes: Maximum Active Database Shows the maximum value "Disk Writes: Active" has reached.
Disk Writes: Commit Files/sec Database Shows the rate at which the database server forces a flush of the disk cache. Windows platforms use unbuffered (direct) I/O, so the disk cache doesn't need to be flushed.
Disk Writes: Database Extends/sec Database Shows the rate at which the database file is extended, in pages/sec.
Disk Writes: Temp Extends/sec Database Shows the rate at which temporary files are extended, in pages/sec.
Disk Writes: Pages/sec Connection and database Shows the rate at which modified pages are being written to disk.
Disk Writes: Transaction Log/sec Connection and database Shows the rate at which pages are written to the transaction log.
Translog Group Commits/sec Connection and database Shows the rate at which a commit of the transaction log was requested but the log had already been written (so the commit was done for free).