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 NameMetric NameMetric Display NameUnitDescription
Sybase - Cachesybase.cache.object.cachedkbSybase Object CacheKBNumber of kilobytes of the cache the object is occupying.
sybase.cachepool.allocatedSybase Cachepool AllocatedKBNumber of bytes allocated for the pool
sybase.cachepool.pages.touchedSybase Cachepool Pages TouchedcountNumber of pages that are currently being used within the pool
sybase.cachepool.pages.readSybase Cachepool Pages ReadcountNumber of pages read into the pool
sybase.cachepool.writesSybase Cachepool WritescountNumber of write operations performed for data in this pool (one write operation may include multiple pages)
sybase.datacache.bufferpoolsSybase Datacache BufferpoolscountNumber of buffer pools within the cache
sybase.datacache.statusSybase Datacache StatusNULLStatus of cache. One of:\nActive\nPending/Active\nPending/Delete\nUpdate Cache\nCache Create\nCache Delete\n(Cluster Edition only) Cache Skip
sybase.datacache.cachesizeSybase Datacache Cache SizeKBTotal size of cache, in kilobytes
sybase.cache.procedure.loadsSybase Cache Procedure LoadscountNumber 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 NameMetric NameMetric Display NameUnitDescription
Sybase - Enginesybase.engine.cpu.timeSybase Engine CPU TimesTotal time, in seconds, the engine has been running.
sybase.engine.connectionsSybase Engine ConnectionscountNumber 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 NameMetric NameMetric Display NameUnitDescription
Sybase - HeapMemorysybase.process.activity.heap.memory.inuseSybase Process Activity In Use Heap MemoryKBCurrent amount, in kilobytes, of heap memory in use.
sybase.process.activity.heap.memory.usedSybase Process Activity Used Heap MemoryKBMaximum amount, in kilobytes, of heap memory used (the high water mark).
sybase.process.activity.heap.memory.reservedSybase Process Activity Reserved Heap MemoryKBAmount, in kilobytes, of heap memory reserved.
sybase.process.activity.heap.memory.allocatedSybase Process Activity Allocated Heap MemoryKBAmount, 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 NameMetric NameMetric Display NameUnitDescription
Sybase - Networksybase.networkio.packets.sentSybase NetworkIO Packets SentcountNumber of packets sent
sybase.networkio.packets.receivedSybase NetworkIO Packets ReceivedcountNumber of packets received
sybase.netwrokio.bytes.sentSybase NetworkIO Bytes SentMBNumber of bytes, in megabytes, sent by the server
sybase.netwrokio.bytes.receivedSybase NetworkIO Bytes ReceivedMBNumber 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 NameMetric NameMetric Display NameUnitDescription
Sybase - Statisticssybase.user.active.connectionsSybase Active User ConnectionscountNumber of active user connections
sybase.user.free.connectionsSybase Inactive User ConnectionscountNumber of inactive user connections available
sybase.locks.freeSybase Inactive LockscountNumber of inactive locks
sybase.locks.activeSybase Active LockscountNumber of active locks
sybase.transaction.descriptor.used.percentSybase Transaction Descriptor Used Percent%percent of the transaction descriptors are currently being used
sybase.user.pct.act.connectionsSybase 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 NameMetric NameMetric Display NameUnitDescription
Sybase - ThreadPoolsybase.threadpool.sizeSybase Threadpool SizecountNumber of threads in the thread pool
sybase.threadpool.tasksSybase Threadpool TaskscountNumber of tasks associated with the thread pool