These statistics describe the amount and type of activity devoted to writing information to disk.
|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 © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|