Sybase
Overview
Sybase, the robust and scalable relational database management system, seamlessly integrates with Motadata AIOps to provide comprehensive monitoring and management capabilities. With this integration, organizations gain real-time visibility into the performance and health of their Sybase databases. Monitor critical database metrics such as query execution times, transaction rates, and database size to ensure efficient data processing and retrieval.
Supported Versions
| Versions |
|---|
| 6.0.0, Adaptive Server Enterprise/16.0 SP03 (Windows) |
| 16 (Linux) |
Prerequisites for Sybase Integration with Motadata AIOps:
Ensure that the Sybase port (default: 5000) is open for the Motadata AIOps server.
Ensure you have the necessary credentials, including the username and password, for Motadata AIOps to connect to the Oracle database.
Ensure that JDBC is supported on the server where Sybase Database is configured.
For agentless monitoring, ensure that the user has the required access for remote access to the Sybase database server. For agent-based monitoring, this is not required.
Ensure that the Sybase service is active and running on the server.
Ensure you have the name of the Sybase database that you want to monitor.
Confirm that the Sybase process and service are listed in the process and service monitor settings of Motadata AIOps. While these may be listed by default, verify that the names of the service and process match the specific Sybase version that you intend to monitor.
By following these prerequisites, you can integrate Sybase with Motadata AIOps and ensure smooth functioning of the monitoring process.
List of Supported KPIs
| Name | Description | Type |
|---|---|---|
| sybase.deadlocks | The number of deadlocks that occurred in Sybase | Count |
| sybase.hits | The number of cache hits in Sybase | Count |
| sybase.misses | The number of cache misses in Sybase | Count |
| sybase.write.bytes.rate | The rate of bytes written in Sybase | Count |
| sybase.read.bytes.rate | The rate of bytes read in Sybase | Count |
| sybase.io.errors | The number of I/O errors encountered in Sybase | Count |
| sybase.version | The version of Sybase | String |
| started.time | The time when Sybase was started | String |
| started.time.sec | The uptime of Sybase in seconds | Count |
| system.tags | The tags associated with the Sybase system | String |
| sybase.procedure.cache.hit.ratio.percent | The hit ratio of the Sybase procedure cache in percentage | Count |
| sybase.buffer.cache.hit.ratio.percent | The hit ratio of the Sybase buffer cache in percentage | Count |
| sybase.active.audit.queue.size | The size of the active audit queue in Sybase | Count |
| sybase.active.compression.pool.size | The size of the active compression pool in Sybase | Count |
| sybase.active.heap.memory.per.user | The amount of active heap memory per user in Sybase | Count |
| sybase.free.heap.memory.per.user | The amount of free heap memory per user in Sybase | Count |
| sybase.heap.memory.per.user.used.percent | The percentage of heap memory per user used in Sybase | Count |
| sybase.active.kernel.resource.memory.bytes | The amount of active kernel resource memory used in Sybase | Count |
| sybase.free.kernel.resource.memory.bytes | The amount of free kernel resource memory available in Sybase | Count |
| sybase.kernel.resource.memory.used.percent | The percentage of kernel resource memory used in Sybase | Count |
| sybase.active.memory.per.worker.process | The amount of active memory per worker process in Sybase | Count |
| sybase.active.java.sockets | The number of active Java sockets in Sybase | Count |
| sybase.active.large.i/o.buffers | The number of active large I/O buffers in Sybase | Count |
| sybase.active.locks | The number of active locks in Sybase | Count |
| sybase.active.databases | The number of active databases in Sybase | Count |
| sybase.txn.to.pss.ratio.used.percent | The percentage of transaction to PSS ratio used in Sybase | Count |
| sybase.active.open.indexes | The number of active open indexes in Sybase | Count |
| sybase.active.open.objects | The number of active open objects in Sybase | Count |
| sybase.active.open.partitions | The number of active open partitions in Sybase | Count |
| sybase.active.remote.connections | The number of active remote connections in Sybase | Count |
| sybase.active.remote.logins | The number of active remote logins in Sybase | Count |
| sybase.active.sort.buffers | The number of active sort buffers in Sybase | Count |
| sybase.active.user.connections | The number of active user connections in Sybase | Count |
| sybase.active.worker.processes | The number of active worker processes in Sybase | Count |
| sybase.active.procedure.cache.size | The size of the active procedure cache in Sybase | Count |
| sybase.active.global.fixed.heap | The size of the active global fixed heap in Sybase | Count |
| sybase.active.process.object.heap | The size of the active process object heap in Sybase | Count |
| sybase.active.shared.class.heap | The size of the active shared class heap in Sybase | Count |
| sybase.active.unilib.cache | The size of the active unilib cache in Sybase | Count |
| sybase.transaction.start.time | The start time of the Sybase transaction | String |
| sybase.transaction.connection.type | The type of connection for the Sybase transaction | String |
| sybase.transaction.name | The name of the Sybase transaction | String |
| sybase.transaction.database.name | The name of the database associated with the transaction in Sybase | String |
| sybase.transaction.coordinator | The coordinator of the Sybase transaction | String |
| sybase.transaction.state | The state of the Sybase transaction | String |
| sybase.transaction.type | The type of the Sybase transaction | String |
| sybase.transaction.program.name | The program name associated with the transaction in Sybase | String |
| sybase.process.name | The name of the Sybase process | String |
| sybase.process.kernel.id | The kernel ID of the Sybase process | Count |
| sybase.process.wait.time.ms | The wait time of the Sybase process in milliseconds | Count |
| sybase.process.id | The ID of the Sybase process | Count |
| sybase.process.priority | The priority of the Sybase process | String |
| sybase.process.status | The status of the Sybase process | String |
| sybase.process.hostname | The hostname of the machine running the process | String |
| sybase.process.command | The command executed by the Sybase process | String |
| sybase.process.client | The client associated with the Sybase process | String |
| sybase.process.io.ops | The number of I/O operations performed by the process | Count |
| sybase.process.memory.bytes | The memory usage in bytes by the Sybase process | Count |
| sybase.process.host | The host of the Sybase process | Count |
| sybase.database | The name of the Sybase database | String |
| sybase.database.durability | The durability level of the Sybase database | String |
| sybase.database.creation.date | The creation date of the Sybase database | String |
| sybase.database.last.dump.transaction | The ID of the last dump transaction for the Sybase database | String |
| sybase.database.id | The ID of the Sybase database | Count |
| sybase.database.user.id | The ID of the user associated with the Sybase database | Count |
| sybase.database.memory.bytes | The total memory usage in bytes by the Sybase database | Count |
| sybase.database.used.memory.bytes | The used memory in bytes by the Sybase database | Count |
| sybase.database.memory.used.percent | The percentage of used memory by the Sybase database | Count |
| sybase.database.backup.start.time | The start time of the backup process for the Sybase database | Count |
| sybase.database.backup.last.checkpoint.time | The time of the last checkpoint during the backup process | Count |
| sybase.database.backup.last.transaction.log.dump.time | The time of the last transaction log dump during the backup process | Count |
| sybase.database.backup.transaction.log.status | The status of the transaction log backup process for the Sybase database | Count |
| sybase.database.backup.suspended.processes | The number of suspended processes during the backup process | Count |
| sybase.database.backup.instance.id | The ID of the backup instance for the Sybase database | Count |