Sybase - Cache
Description
Monitors the sybase - cache object metrics like cache pool allocated, write, pages touched, pages read, data cache bufferpools, status and cache size. Validated this template on Sybase ASE 16
Prerequisites
Database credentials should be attached against the device in portal.
Supported Metric
| Monitor Name | Metric Name | Metric Display Name | Unit | Description |
|---|---|---|---|---|
| Sybase - Cache | sybase.cache.object.cachedkb | Sybase Object Cache | KB | Number of kilobytes of the cache the object is occupying. |
| sybase.cachepool.allocated | Sybase Cachepool Allocated | KB | Number of bytes allocated for the pool | |
| sybase.cachepool.pages.touched | Sybase Cachepool Pages Touched | count | Number of pages that are currently being used within the pool | |
| sybase.cachepool.pages.read | Sybase Cachepool Pages Read | count | Number of pages read into the pool | |
| sybase.cachepool.writes | Sybase Cachepool Writes | count | Number of write operations performed for data in this pool (one write operation may include multiple pages) | |
| sybase.datacache.bufferpools | Sybase Datacache Bufferpools | count | Number of buffer pools within the cache | |
| sybase.datacache.status | Sybase Datacache Status | NULL | Status of cache. One of:\nActive\nPending/Active\nPending/Delete\nUpdate Cache\nCache Create\nCache Delete\n(Cluster Edition only) Cache Skip | |
| sybase.datacache.cachesize | Sybase Datacache Cache Size | KB | Total size of cache, in kilobytes | |
| sybase.cache.procedure.loads | Sybase Cache Procedure Loads | count | Number of stored procedures loaded into cache |
Sybase - Engine
Description
It monitors the sybase - engine object metrics like CPU time and engine connections. Validated this template on Sybase ASE 16
Prerequisites
Database credentials should be attached against the device in portal.
Supported Metric
| Monitor Name | Metric Name | Metric Display Name | Unit | Description |
|---|---|---|---|---|
| Sybase - Engine | sybase.engine.cpu.time | Sybase Engine CPU Time | s | Total time, in seconds, the engine has been running. |
| sybase.engine.connections | Sybase Engine Connections | count | Number of connections this engine handles. |
Sybase - HeapMemory
Description
Monitors the sybase - heap memory metrics like process activity inuse, used, reserved and allocated. Validated this template on Sybase ASE 16
Prerequisites
Database credentials should be attached against the device in portal.
Supported Metric
| Monitor Name | Metric Name | Metric Display Name | Unit | Description |
|---|---|---|---|---|
| Sybase - HeapMemory | sybase.process.activity.heap.memory.inuse | Sybase Process Activity In Use Heap Memory | KB | Current amount, in kilobytes, of heap memory in use. |
| sybase.process.activity.heap.memory.used | Sybase Process Activity Used Heap Memory | KB | Maximum amount, in kilobytes, of heap memory used (the high water mark). | |
| sybase.process.activity.heap.memory.reserved | Sybase Process Activity Reserved Heap Memory | KB | Amount, in kilobytes, of heap memory reserved. | |
| sybase.process.activity.heap.memory.allocated | Sybase Process Activity Allocated Heap Memory | KB | Amount, in kilobytes, of heap memory allocated. |
Sybase - Network
Description
It Monitors the sybase - network related metrics like packets sent, received, bytes sent and bytes received. Validated this template on Sybase ASE 16
Prerequisites
Database credentials should be attached against the device in portal.
Supported Metric
| Monitor Name | Metric Name | Metric Display Name | Unit | Description |
|---|---|---|---|---|
| Sybase - Network | sybase.networkio.packets.sent | Sybase NetworkIO Packets Sent | count | Number of packets sent |
| sybase.networkio.packets.received | Sybase NetworkIO Packets Received | count | Number of packets received | |
| sybase.netwrokio.bytes.sent | Sybase NetworkIO Bytes Sent | MB | Number of bytes, in megabytes, sent by the server | |
| sybase.netwrokio.bytes.received | Sybase NetworkIO Bytes Received | MB | Number of bytes, in megabytes, received by the server |
Sybase - Statistics
Description
Monitors the sybase - statistics metrics like active user connections, inactive user connections, inactive locks, active locks, transaction descriptor used percent and user pct active connections. Validated this template on Sybase ASE 16
Prerequisites
Database credentials should be attached against the device in portal.
Supported Metric
| Monitor Name | Metric Name | Metric Display Name | Unit | Description |
|---|---|---|---|---|
| Sybase - Statistics | sybase.user.active.connections | Sybase Active User Connections | count | Number of active user connections |
| sybase.user.free.connections | Sybase Inactive User Connections | count | Number of inactive user connections available | |
| sybase.locks.free | Sybase Inactive Locks | count | Number of inactive locks | |
| sybase.locks.active | Sybase Active Locks | count | Number of active locks | |
| sybase.transaction.descriptor.used.percent | Sybase Transaction Descriptor Used Percent | % | percent of the transaction descriptors are currently being used | |
| sybase.user.pct.act.connections | Sybase User Pct Act Connections | % | Percent of the active user connections |
Sybase - ThreadPool
Description
Monitors the sybase - threadpool object metrics like threadpool size and thread pool tasks. Validated this template on Sybase ASE 16
Prerequisites
Database credentials should be attached against the device in portal
Supported Metric
| Monitor Name | Metric Name | Metric Display Name | Unit | Description |
|---|---|---|---|---|
| Sybase - ThreadPool | sybase.threadpool.size | Sybase Threadpool Size | count | Number of threads in the thread pool |
| sybase.threadpool.tasks | Sybase Threadpool Tasks | count | Number of tasks associated with the thread pool |