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). |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |