Sybase Adaptive Server Anywhere - Page 1119

Appendix A Database Performance and Connection Properties
1101
Property Description
ServerIdleWaits
The number of times the server has gone idle waiting
for IO completion or a new request.
TotalBuffers
The total number of network buffers.
TriggerPages
The number of relocatable heap pages used for
triggers.
UnschReq
The number of requests that are currently queued up
waiting for an available server thread.
ViewPages
The number of relocatable heap pages used for views.
Database-level properties
The following table lists properties available for each database on the server.
v To retrieve the value of a database property:
♦ Use the db_property system function: For example, the following
statement returns the page size of the current database:
select db_property ( ’PageSize’)
v To retrieve the values of all database properties:
♦ Use the sa_db_properties system procedure:
call sa_db_properties
Property Description
Alias
The database name.
CharSet
The character set of the database.
CheckpointUrgency
The time that has elapsed since the last checkpoint, as
a percentage of the checkpoint time setting of the
database.
CurrentRedoPos
The current offset in the transaction log file, where
the next database operation is to be logged.
ConnCount
The number of connections to the database.
File
The file name of the database root file, including path.
FileVersion
The version of the database file. This does not
correspond to a software release version.
GlobalDBId
The value of the GLOBAL_DATABASE_ID option
used to generate unique primary key values in a
Examples
Descriptions