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 sampled every second. 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 sampled every second. 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. |