Sybase Adaptive Server Anywhere - Page 1115

Appendix A Database Performance and Connection Properties
1097
Property Description
CompanyName
The name of the company owning this software.
ConnsDisabled
Returns ON or OFF, to indicate the current setting of
the server option to disable new connections.
$ For information, see "sa_server_option system
procedure" on page 971.
CurrentCacheSize
The current cache size, in kilobytes.
CurrIO
The current number of file IOs that were issued by the
server but have not yet completed.
CurrRead
The current number of file reads that were issued by
the server but have not yet completed.
CurrWrite
The current number of file writes that were issued by
the server but have not yet completed.
DefaultCollation
The collation that would be used for new databases, if
none is explicitly specified.
DiskRead
The number of pages that have been read from disk.
DiskReadIndInt
The number of index internal-node pages that have
been read from disk.
DiskReadIndLeaf
The number of index leaf pages that have been read
from disk.
DiskReadTable
The number of table pages that have been read from
disk.
DiskWrite
The number of modified pages that have been written
to disk.
ExtendDB
The number of pages by which the database file has
been extended.
ExtendTempWrite
The number of pages by which temporary files have
been extended.
FreeBuffers
The number of available network buffers.
FullCompare
The number of comparisons that have been performed
beyond the hash value in an index.
IdleCheck
The number of times that the server’s idle thread has
become active to do idle writes, idle checkpoints, and
so on.
IdleChkpt
The number of checkpoints completed by the server’s
idle thread. An idle checkpoint occurs whenever the
idle thread writes out the last dirty page in the cache.
IdleChkTime
The number of 100ths of a second spent checkpointing
during idle IO.