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.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |