Appendix A Database Performance and Connection Properties
1087
Statistic Scope Description
Disk Writes:
Active
Database The current number of file writes issued
by the engine which are not yet
completed.
Disk Writes:
Maximum Active
Database The maximum value "Disk Writes:
Active" has reached.
Disk Writes:
Commit Files
Database The rate at which the engine forces a
flush of the disk cache. Windows NT and
NetWare platforms use unbuffered
(direct) I/O, so the disk cache does not
need to be flushed.
Disk Writes:
Extend Database
Database The rate (in pages/sec) at which the
database file is extended.
Disk Writes:
Extend Temporary
File
Database The rate (in pages/sec) at which
temporary files are extended.
Disk Writes:
Pages
Connection
Database
The rate at which modified pages are
being written to disk.
Disk Writes:
Transaction log
Connection
Database
The rate at which pages are written to the
transaction log.
Disk Writes:
Transaction Log
Group Commits
Connection
Database
Occurs when a commit of the transaction
log is requested but the log has already
been written (so the commit was done for
"free").
These statistics describe the use of the index.
Statistic Scope Description
Index:
Adds
Connection
Database
The rate at which entries are added to
indexes.
Index:
Lookups
Connection
Database
The rate at which entries are looked up in
indexes.
Index:
Full compares
Connection
Database
The rate at which comparisons beyond
the hash value in an index must be
performed.
These statistics describe the memory used by the Java VM.
Index statistics
Java VM statistics
To Next Page
Loading...