Performance Monitor statistics

ASA Database Administration Guide
Database Performance and Connection Properties
Database performance statistics

Performance Monitor statistics

The Windows Performance Monitor is an application for viewing the behavior of objects such as processors, memory, and applications. Adaptive Server Anywhere provides many statistics for the Performance Monitor to display.

For information on how to use the Performance Monitor, see Monitoring database statistics from Windows Performance Monitor.

Adaptive Server Anywhere makes statistics available for the Performance Monitor. Rates are reported per second. The statistics are grouped into the following areas:

Cache statistics

These statistics describe the use of the cache.

Statistic	Scope	Description
Cache Hits/sec	Connection and Database	The rate at which database page lookups are satisfied by finding the page in the cache.
Cache Reads: Index Interior/sec	Connection and Database	The rate at which index internal-node pages are read from the cache.
Cache Reads: Index Leaf/sec	Connection and Database	The rate at which index leaf pages are read from the cache.
Cache Reads: Table/sec	Connection and Database	The rate at which table pages are read from the cache.
Cache Reads: Total Pages/sec	Connection and Database	The rate at which database pages are looked up in the cache.
Cache Size: Current	Engine	The current size of the database server cache, in kilobytes.
Cache Size: Maximum	Engine	The maximum allowed size of the database server cache, in kilobytes.
Cache Size: Minimum	Engine	The minimum allowed size of the database server cache, in kilobytes.
Cache Size: Peak	Engine	The peak size of the database server cache, in kilobytes.

Checkpoint and recovery statistics

These statistics isolate the checkpoint and recovery actions performed when the database is in an idle state.

Statistic	Scope	Description
Checkpoint Flushes/sec	Database	The rate at which ranges of adjacent pages are written out during a checkpoint.
Checkpoint Log	Database	The rate at which the transaction log is checkpointed.
Checkpoint Urgency	Database	Checkpoint Urgency, expressed as a percentage.
Checkpoints/sec	Database	The rate at which checkpoints are performed.
Idle Actives/sec	Database	Database The rate at which the engine's idle thread becomes active to do idle writes, idle checkpoints, etc.
Idle Checkpoint Time	Database	The total time spent doing idle checkpoints, in seconds.
Idle Checkpoints/sec	Database	The rate at which checkpoints are completed by the engine's idle thread. An idle checkpoint occurs whenever the idle thread writes out the last dirty page in the cache.
Idle Writes/sec	Database	The rate at which disk writes are issued by the engine's idle thread.
Recovery I/O Estimate	Database	The estimated number of I/O operations required to recover the database.
Recovery Urgency	Database	Recovery Urgency expressed as a percentage.

Communications statistics

These statistics describe client/server communications activity.

Statistic	Scope	Description
Comm: Buffer Misses	Server	The total number of network buffer allocations exceeding the connection buffer pool.
Comm: Bytes Received/sec	Connection and Server	The rate at which network data (in bytes) are received.
Comm: Bytes Received Uncompressed/sec	Connection and Server	The rate at which bytes would have been received if compression was disabled.
Comm: Bytes Sent/sec	Connection and Server	The rate at which bytes are transmitted over the network.
Comm: Bytes Sent Uncompressed/sec	Connection and Server	The rate at which bytes would have been sent if compression was disabled.
Comm: Free Buffers	Server	Number of free network buffers.
Comm: Licenses in Use	Server	The number of unique client network addresses connected.
Comm: Multi-packets Received/sec	Server	The rate at which multi-packet deliveries are received.
Comm: Multi-packets Sent/sec	Server	The rate at which multi-packet deliveries are transmitted.
Comm: Packets Received/sec	Connection and Server	The rate at which network packets are received.
Comm: Packets Received Uncompressed/sec	Connection and Server	The rate at which network packets would have been received if compression was disabled.
Comm: Packets Sent/sec	Connection and Server	The rate at which network packets are transmitted.
Comm: Packets Sent Uncompressed/sec	Connection and Server	The rate at which network packets would have been transmitted if compression was disabled.
Comm: Send Fails/sec	Server	The rate at which the underlying protocol(s) failed to send a packet.
Comm: TotalBuffers	Server	The total number of network buffers.

Disk I/O statistics

These statistics combine disk reads and disk writes to give overall information about the amount of activity devoted to disk I/O.

Statistic	Scope	Description
Disk: Active I/O	Database	The current number of file I/Os issued by the engine which have not yet completed.
Disk: Maximum I/O	Database	The maximum value "Disk Reads: Active I/O" has reached.

Disk read statistics

These statistics describe the amount and type of activity devoted to reading information from disk.

Statistic	Scope	Description
Disk Reads: Total Pages/sec	Connection and Database	The rate at which pages are read from a file.
Disk Reads: Active	Database	The current number of file reads issued by the engine which have not yet completed.
Disk Reads: Index interior/sec	Connection and Database	The rate at which index internal-node pages are being read from disk.
Disk Reads: Index leaf/sec	Connection and Database	The rate at which index leaf pages are being read from disk.
Disk Reads: Table/sec	Connection and Database	The rate at which table pages are being read from disk.
Disk Reads: Maximum Active	Database	The maximum value "Disk Reads: Active" has reached.

Disk write statistics

These statistics describe the amount and type of activity devoted to writing information to disk.

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/sec	Database	The rate at which the engine forces a flush of the disk cache. Windows NT/2000/XP and NetWare platforms use unbuffered (direct) I/O, so the disk cache does not need to be flushed.
Disk Writes: Database Extends/sec	Database	The rate at which the database file is extended, in pages/sec.
Disk Writes: Temp Extends/sec	Database	The rate at which temporary files are extended, in pages/sec.
Disk Writes: Pages/sec	Connection and Database	The rate at which modified pages are being written to disk.
Disk Writes: Transaction Log/sec	Connection and Database	The rate at which pages are written to the transaction log.
Disk Writes: Transaction Log Group Commits	Connection and 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").

Index statistics

These statistics describe the use of the index.

Statistic	Scope	Description
Index: Adds/sec	Connection and Database	The rate at which entries are added to indexes.
Index: Lookups/sec	Connection and Database	The rate at which entries are looked up in indexes.
Index: Full Compares/sec	Connection and Database	The rate at which comparisons beyond the hash value in an index must be performed.

Java VM statistics

These statistics describe the memory used by the Java VM.

Statistic	Scope	Description
JVM: Global Fixed Size	Server	The total bytes allocated to the Java VM fixed heap.
JVM: Heap Size	Connection and Database	The total bytes allocated to connection Java VMs
JVM: Namespace Size	Database	The total number of bytes allocated to the Java VM namespace.

Memory pages statistics

These statistics describe the amount and purpose of memory used by the database server.

Statistic	Scope	Description
Mem Pages: Locked Heap	Server	The number of heap pages locked in the cache.
Mem Pages: Lock Table	Database	The number of pages used to store lock information.
Mem Pages: Rollback Log	Connection and Database	The number of pages in the rollback log.
Mem Pages: Main Heap	Server	The number of pages used for global engine data structures.
Mem Pages: Map Pages	Database	The number of map pages used for accessing the lock table, frequency table, and table layout.
Mem Pages: Procedure Definitions	Database	The number of relocatable heap pages used for procedures.
Mem Pages: Relocatable	Database	The number of pages used for relocatable heaps (cursors, statements, procedures, triggers, views, etc.).
Mem Pages: Relocations/sec	Database	The rate at which relocatable heap pages are read from the temporary file.
Mem Pages: Trigger Definitions	Database	The number of relocatable heap pages used for triggers.
Mem Pages: View Definitions	Database	The number of relocatable heap pages used for views.

Request statistics

These statistics describe the database server activity devoted to responding to requests from client applications.

Statistic	Scope	Description
Requests	Server	The rate at which the engine is entered to allow it to handle a new request or continue processing an existing request.
Requests: Active	Server	The number of engine threads currently handling a request.
Requests: Unscheduled	Server	The number of requests that are currently queued up waiting for an available engine thread.
Cursors	Connection	The number of declared cursors currently maintained by the engine.
Cursors Open	Connection	The number of open cursors currently maintained by the engine.
Statements	Connection	The number of prepared statements currently maintained by the engine.
Statement Prepares	Connection	The rate at which statement prepares are being handled by the engine.
Transaction Commits	Connection	The rate at which Commit requests are handled.
Transaction Rollbacks	Connection	The rate at which Rollback requests are handled.

Miscellaneous statistics

Statistic	Scope	Description
Avail IO	Server	Expressed as a count.
Connection Count	Database	The number of connections to this database.
Main Heap Bytes	Server	The number of bytes used for global engine data structures.
Query Low Memory Strategy	Connection and Database	The number of times the server changed its execution plan during execution because of low memory conditions.
Temporary Table Pages	Connection and Database	The number of pages in the temporary file used for temporary tables.