Sybase ASE and IQ Server Metrics

Sybase ASE

Metrics Description
BytesReceived The number of bytes received during client/server communications. This value is updated for HTTP and HTTPS connections.
BytesSent The number of bytes sent during client/server communications. This value is updated for HTTP and HTTPS connections.
Connections The number of connections to the database.
Deletes The number of deferred and direct row deletes from the allpages-locked tables.
DiskIOChecks

The number of times the engine checked for asynchronous disk I/O.

Modify the frequency of these checks with the i/o polling process count.
DiskIOCompleted

The number of asynchronous disk I/Os completed when the engine polled for outstanding asynchronous disk I/O.
DiskIOPolled

The number of times the engine polled for completion of outstanding asynchronous disk I/O. The polling occurs whenever disk I/O checks indicate that asynchronous I/O is posted but still not complete.
IndexAccesses

The number of pages read that Adaptive Server retrieves using an index.
Inserts The total number of insert operations executed.
LogicalReads The number of buffers read from the cache.
MaxOutstandingIOs

The current number of I/O requests initiated by the engine that are not completed.
Merges The total number of merge operations executed.
PacketsReceived

The number of packets received.
PacketsSent

The number of packets sent.
PhysicalReads

The number of buffers read from disk.
PhysicalWrites The numbers of buffers written to disk from the cache.
Rollbacks

The number of transactions rolled back by the process.
Selects The total number of select operations executed.
TableAccesses

The number of pages read that Adaptive Server retrieves without using an index.
TempDbObjects

The total number of temporary tables created using the process.
Total Lock Time

Total lock time is calculated based on the number of blocking sessions per second granularity. This does not consider the duration when a transaction is rolled back during a session-level or server-level lock timeout.
Transactions The currently running transaction.
ULCFlushes The total number of times the user log cache is flushed.
ULCFlushFull

The number of times the user log cache is flushed because it was full.
Updates The total number of Update operations executed.
WorkTables The number of Worktables that are automatically created in tempdb by Adaptive Server.
Yields The number of times a task is completed or yielded after running for the configured amount of time.

Sybase IQ

Metrics Description
ActiveReq Returns the number of server threads that are currently handling a request.
ActiveVersionsCount Count of Active Transaction Versions.
ActiveVersionsCreateMB Size in Mb of versions for the active transaction.
ActiveVersionsDeleteMB Size in Mb of versions for active transactions.
BytesReceived Returns the number of bytes received during client/server communications. This value is updated for HTTP and HTTPS connections.
BytesReceivedUncomp Returns the number of bytes that would have been received during client/server communications if compression was disabled. (This value is the same as the value for BytesReceived if compression is disabled.)
BytesSent Returns the number of bytes sent during client/server communications. This value is updated for HTTP and HTTPS connections.
BytesSentUncomp Returns the number of bytes that would have been sent during client/server communications if compression was disabled. (This value is the same as the value for BytesSent if compression is disabled.)
CacheFileDirty Returns the number of cache pages that are dirty (needing a write).
CacheFree Returns the number of cache pages not being used.
CacheHits Returns the number of database page lookups.
CachePanics Returns the number of times the cache manager has failed to find a page to allocate.
CachePinned Returns the number of pinned cache pages.
CacheRead Returns the number of cache reads.
CacheReplacements Returns the number of pages in the cache that have been replaced.
CacheScavenges Returns the number of times the cache manager has scavenged for a page to allocate.
Connections The number of connections to the database.
DiskRead Returns the number of disk reads.
OtherVersionsCount Shows count of other db versions. These versions will eventually be dropped when they are no longer referenced or referencable by active transactions.
OtherVersionsMB Shows space usage in MB of other db versions. These versions will eventually be dropped when they are no longer referenced or referencable by active transactions.
ProcessCPU Returns CPU usage for the database server process. Values are in seconds. This property is supported on Windows and Unix. This property is not supported on Windows Mobile.
ProcessCPUSystem Returns system CPU usage for the database server process CPU. This is the amount of CPU time that the database server spent inside the operating system kernel. Values are in seconds. This property is supported on Windows and Unix. This property is not supported on Windows Mobile.
ProcessCPUUser Returns user CPU usage for the database server process. Values are in seconds. This excludes the amount of CPU time that the database server spent inside the operating system kernel. This property is supported on Windows and Unix. This property is not supported on Windows Mobile.
RequestsReceived Requests received by the server.
TempBufferCapacityCount Capacity count of Temporary Buffers.
TempBufferCapacityMB Capacity in Mb of Temporary Buffers.
TempBufferLockedCount The number of Temporary Buffers that are locked.
TempBufferUsedCount The number of Temporary Buffers in use.
Total Lock Time Total lock time is calculated based on the number of blocking sessions per second granularity. This does not consider the duration when a transaction is rolled back during a session-level or server-level lock timeout.
Transactions The number of transactions.