SAP MAX DB
Overview
SAP MaxDB, the powerful and high-performance 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 SAP MaxDB 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 |
|---|
| 7.9.09 |
Prerequisites for SAP MaxDB Integration with Motadata AIOps:
Ensure that the SAP MaxDB port (default: 7210) 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 SAP MaxDB database.
Ensure that JDBC is supported on the server where SAP MaxDB Database is configured.
For agentless monitoring, ensure that the user has the required access for remote access to the SAP MaxDB database server. For agent-based monitoring, this is not required.
Ensure that the SAP MaxDB service is active and running on the server.
Ensure you have the name of the SAP MaxDB database that you want to monitor.
Confirm that the SAP MaxDB 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 SAP MaxDB version that you intend to monitor.
By following these prerequisites, you can integrate SAP MaxDB with Motadata AIOps and ensure smooth functioning of the monitoring process.
List of Supported KPIs
| Name | Description | Type |
|---|---|---|
| sap.maxdb.row.locks | Number of row locks in SAP MaxDB | Count |
| sap.maxdb.table.locks | Number of table locks in SAP MaxDB | Count |
| sap.maxdb.pin.area.data.cache.used.bytes | Amount of used bytes in the SAP MaxDB pin area data cache | Count |
| sap.maxdb.temporary.converter.used.bytes | Amount of used bytes in the SAP MaxDB temporary converter | Count |
| sap.maxdb.shadow.data.used.bytes | Amount of used bytes in the SAP MaxDB shadow data | Count |
| sap.maxdb.permanent.converter.used.bytes | Amount of used bytes in the SAP MaxDB permanent converter | Count |
| system.tags | Tags associated with the SAP MaxDB system | String |
| sap.maxdb.kernel.version | Version of the SAP MaxDB kernel | String |
| sap.maxdb.catalog.cache.bytes | Amount of used bytes in the SAP MaxDB catalog cache | Count |
| sap.maxdb.data.used.bytes | Amount of used bytes in the SAP MaxDB data | Count |
| sap.maxdb.data.provisioned.bytes | Amount of provisioned bytes in the SAP MaxDB data | Count |
| sap.maxdb.incremental.backup.bytes | Amount of incremental backup bytes in the SAP MaxDB | Count |
| sap.maxdb.permanent.data.used.bytes | Amount of used bytes in the SAP MaxDB permanent data | Count |
| sap.maxdb.temporary.data.used.bytes | Amount of used bytes in the SAP MaxDB temporary data | Count |
| sap.maxdb.run.directory.path | Path to the run directory in SAP MaxDB | String |
| sap.maxdb.instance.type | Type of SAP MaxDB instance | String |
| sap.maxdb.sequence.cache.bytes | Amount of used bytes in the SAP MaxDB sequence cache | Count |
| sap.maxdb.oms.max.heap.bytes | Maximum heap size for the SAP MaxDB OMS (Offline Management System) | Count |
| sap.maxdb.shared.sql.cache.bytes | Amount of shared SQL cache bytes in SAP MaxDB | Count |
| sap.maxdb.data.used.percent | Percentage of used data in SAP MaxDB | Count |
| sap.maxdb.data.free.percent | Percentage of free data in SAP MaxDB | Count |
| sap.maxdb.data.free.bytes | Amount of free data bytes in SAP MaxDB | Count |
| sap.maxdb.log.used.bytes | Amount of used log bytes in SAP MaxDB | Count |
| sap.maxdb.log.provisioned.bytes | Amount of provisioned log bytes in SAP MaxDB | Count |
| sap.maxdb.log.used.percent | Percentage of used log space in SAP MaxDB | Count |
| sap.maxdb.log.area.full | Indicates whether the log area in SAP MaxDB is full | String |
| sap.maxdb.logging.status | Current logging status in SAP MaxDB | String |
| sap.maxdb.log.auto.overwrite | Indicates whether automatic log overwrite is enabled in SAP MaxDB | String |
| sap.maxdb.log.flush.mode | Log flush mode setting in SAP MaxDB | String |
| sap.maxdb.log.device.state | State of the log device in SAP MaxDB | String |
| sap.maxdb.log.writer.status | Status of the log writer in SAP MaxDB | String |
| sap.maxdb.io.buffer.file.directory.bytes | Amount of used bytes in the SAP MaxDB I/O buffer file directory | Count |
| sap.maxdb.io.buffer.block.allocator.bytes | Amount of used bytes in the SAP MaxDB I/O buffer block allocator | Count |
| sap.maxdb.io.buffer.converter.bytes | Amount of used bytes in the SAP MaxDB I/O buffer converter | Count |
| sap.maxdb.io.buffer.log.queue.cache.bytes | Amount of used bytes in the SAP MaxDB I/O buffer log queue cache | Count |
| sap.maxdb.io.buffer.index.bytes | Amount of used bytes in the SAP MaxDB I/O buffer index | Count |
| sap.maxdb.io.buffer.cache.bytes | Amount of used bytes in the SAP MaxDB I/O buffer cache | Count |
| sap.maxdb.io.buffer.data.cache.bytes | Amount of used bytes in the SAP MaxDB I/O buffer for data cache | Count |
| sap.maxdb.io.buffer.management.bytes | Amount of used bytes in the SAP MaxDB I/O buffer for management | Count |
| sap.maxdb.io.buffer.free.bytes | Amount of free bytes in the SAP MaxDB I/O buffer | Count |
| sap.maxdb.changed.data.cache.bytes | Amount of used bytes in the SAP MaxDB changed data cache | Count |
| sap.maxdb.oms.data.cache.bytes | Amount of used bytes in the SAP MaxDB OMS data cache | Count |
| sap.maxdb.sql.data.cache.bytes | Amount of used bytes in the SAP MaxDB SQL data cache | Count |
| sap.maxdb.history.data.cache.bytes | Amount of used bytes in the SAP MaxDB history data cache | Count |
| sap.maxdb.latest.backup.thread.id | Latest backup thread ID in SAP MaxDB | Count |
| sap.maxdb.latest.backup.thread.name | Name of the latest backup thread in SAP MaxDB | Count |
| sap.maxdb.automatic.log.backup | Indicator of automatic log backup in SAP MaxDB | Count |
| sap.maxdb.latest.backup.io.ops | Number of I/O operations for the latest backup in SAP MaxDB | Count |
| sap.maxdb.latest.backup.io.pages | Number of I/O pages for the latest backup in SAP MaxDB | Count |
| sap.maxdb.latest.backup.pending.io.calls | Number of pending I/O calls for the latest backup in SAP MaxDB | Count |
| sap.maxdb.latest.backup.path | Path of the latest backup in SAP MaxDB | Count |
| sap.maxdb.latest.backup.io.time.ms | I/O time in milliseconds for the latest backup in SAP MaxDB | Count |
| sap.maxdb.sql.lock.request.timeouts | Number of SQL lock request timeouts in SAP MaxDB | Count |
| sap.maxdb.oms.lock.request.timeouts | Number of OMS lock request timeouts in SAP MaxDB | Count |
| sap.maxdb.holding.locks.transactions | Number of transactions holding locks in SAP MaxDB | Count |
| sap.maxdb.requesting.locks.transactions | Number of transactions requesting locks in SAP MaxDB | Count |
| sap.maxdb.used.locks | Number of used locks in SAP MaxDB | Count |
| sap.maxdb.used.escalations | Number of lock escalations used in SAP MaxDB | Count |
| sap.maxdb.dead.locks | Number of deadlocks in SAP MaxDB | Count |
| sap.maxdb.oms.lock.collisions | Number of OMS lock collisions in SAP MaxDB | Count |
| sap.maxdb.maximum.locks | Maximum number of locks in SAP MaxDB | Count |
| sap.maxdb.sql.lock.collisions | Number of SQL lock collisions in SAP MaxDB | Count |
| sap.maxdb.entry.lock.used.percent | Percentage of used entry locks in SAP MaxDB | Count |
| sap.maxdb.schema | SAP MaxDB schema | String |
| sap.maxdb.schema.used.bytes | Used bytes in the SAP MaxDB schema | Count |
| sap.maxdb.schema.tables | Number of tables in the SAP MaxDB schema | Count |
| sap.maxdb.resource.monitor.id | Identifier of the SAP MaxDB resource monitor | Count |
| sap.maxdb.resource.monitor.sql.query | SQL query associated with the SAP MaxDB resource monitor | String |
| sap.maxdb.resource.monitor.executions | Number of executions for the SAP MaxDB resource monitor | Count |
| sap.maxdb.resource.monitor.qualified.rows | Number of qualified rows for the SAP MaxDB resource monitor | Count |
| sap.maxdb.resource.monitor.virtual.reads | Number of virtual reads for the SAP MaxDB resource monitor | Count |
| sap.maxdb.resource.monitor.fetched.rows | Number of fetched rows for the SAP MaxDB resource monitor | Count |
| sap.maxdb.resource.monitor.vwaits | Number of vwaits (resource waits) for the SAP MaxDB resource monitor | Count |
| sap.maxdb.resource.monitor.physical.io.ops | Number of physical I/O operations for the SAP MaxDB resource monitor | Count |
| sap.maxdb.resource.monitor.session.id | Identifier of the session associated with the resource monitor | Count |
| sap.maxdb.resource.monitor.runtime.ms | Runtime duration of the SAP MaxDB resource monitor in milliseconds | Count |
| sap.maxdb.oms.heap | SAP MaxDB OMS heap | String |
| sap.maxdb.oms.heap.used.bytes | Number of bytes used in the SAP MaxDB OMS heap | Count |
| sap.maxdb.oms.heap.max.used.bytes | Maximum number of bytes used in the SAP MaxDB OMS heap | Count |
| sap.maxdb.oms.heap.reserved.bytes | Number of bytes reserved in the SAP MaxDB OMS heap | Count |
| sap.maxdb.log.volume | SAP MaxDB Log Volume | Count |
| sap.maxdb.log.volume.bytes | Total number of bytes in the SAP MaxDB Log Volume | Count |
| sap.maxdb.log.volume.used.bytes | Number of bytes used in the SAP MaxDB Log Volume | Count |
| sap.maxdb.log.volume.path | Path of the SAP MaxDB Log Volume | String |
| sap.maxdb.log.volume.used.percent | Percentage of the SAP MaxDB Log Volume used | Count |
| sap.maxdb.lock.id | ID of the SAP MaxDB lock | String |
| sap.maxdb.lock.duration.sec | Duration of the SAP MaxDB lock in seconds | Count |
| sap.maxdb.lock.table.id | ID of the table associated with the SAP MaxDB lock | String |
| sap.maxdb.lock.schema | Schema name associated with the SAP MaxDB lock | String |
| sap.maxdb.lock.mode | Mode of the SAP MaxDB lock | String |
| sap.maxdb.lock.remote.host.process | Process ID of the remote host associated with the SAP MaxDB lock | Count |
| sap.maxdb.lock.table.name | Name of the table associated with the SAP MaxDB lock | String |
| sap.maxdb.lock.duration | Duration of the SAP MaxDB lock | String |
| sap.maxdb.lock.user | User associated with the SAP MaxDB lock | String |
| sap.maxdb.lock.session | Session ID associated with the SAP MaxDB lock | Count |
| sap.maxdb.lock.remote.host | Remote host associated with the SAP MaxDB lock | String |
| sap.maxdb.lock.owner | Owner of the SAP MaxDB lock | String |
| sap.maxdb.lock.waiter.id | ID of the waiter for the SAP MaxDB lock | String |
| sap.maxdb.lock.owner.schema | Schema name of the owner of the SAP MaxDB lock | String |
| sap.maxdb.lock.waiter.duration | Duration of the waiter for the SAP MaxDB lock | String |
| sap.maxdb.lock.owner.remote.host | Remote host of the owner of the SAP MaxDB lock | String |
| sap.maxdb.lock.waiter.request.mode | Request mode of the SAP MaxDB lock waiter | String |
| sap.maxdb.lock.waiter.schema | Schema name of the SAP MaxDB lock waiter | String |
| sap.maxdb.lock.waiter.table.id | ID of the table associated with the SAP MaxDB lock waiter | String |
| sap.maxdb.lock.owner | Owner of the SAP MaxDB lock | String |
| sap.maxdb.lock.owner.duration | Duration of the SAP MaxDB lock owner | String |
| sap.maxdb.lock.waiter.username | Username of the SAP MaxDB lock waiter | String |
| sap.maxdb.lock.owner.user | User associated with the SAP MaxDB lock owner | String |
| sap.maxdb.lock.waiter.table.name | Name of the table associated with the SAP MaxDB lock waiter | String |
| sap.maxdb.lock.waiter.remote.host | Remote host associated with the SAP MaxDB lock waiter | String |
| sap.maxdb.lock.waiter.owner | Owner associated with the SAP MaxDB lock waiter | String |
| sap.maxdb.lock.owner.lock.mode | Lock mode of the SAP MaxDB lock owner | String |
| sap.maxdb.lock.waiter.request.timeout | Request timeout of the SAP MaxDB lock waiter | Count |
| sap.maxdb.lock.waiter.duration.sec | Duration of the SAP MaxDB lock waiter in seconds | Count |
| sap.maxdb.lock.owner.duration.sec | Duration of the SAP MaxDB lock owner in seconds | String |
| sap.maxdb.lock.owner.session | Session ID associated with the SAP MaxDB lock owner | String |
| sap.maxdb.lock.waiter.remote.host.process | Process ID of the remote host associated with the SAP MaxDB lock waiter | Count |
| sap.maxdb.lock.owner.remote.host.process | Process ID of the remote host associated with the SAP MaxDB lock owner | String |
| sap.maxdb.lock.waiter.session | Session ID associated with the SAP MaxDB lock waiter | Count |
| sap.maxdb.lock.waiter.state | State of the SAP MaxDB lock waiter | String |
| sap.maxdb.data.volume | The total volume of SAP MaxDB data | Count |
| sap.maxdb.data.volume.bytes | The total volume of SAP MaxDB data in bytes | Count |
| sap.maxdb.data.volume.used.bytes | The used volume of SAP MaxDB data in bytes | Count |
| sap.maxdb.data.volume.used.percent | The percentage of used volume in relation to the total volume | Count |
| sap.maxdb.data.volume.path | The path of the SAP MaxDB data volume | String |
| sap.maxdb.command.monitor.id | The ID of the SAP MaxDB command monitor | Count |
| sap.maxdb.command.monitor.sql.query | The SQL query executed by the SAP MaxDB command monitor | String |
| sap.maxdb.command.monitor.owner | The owner of the SAP MaxDB command monitor | String |
| sap.maxdb.command.monitor.qualified.rows | The number of rows affected by the executed query | Count |
| sap.maxdb.command.monitor.virtual.reads | The number of virtual reads performed by the executed query | Count |
| sap.maxdb.command.monitor.vwaits | The number of waits experienced by the SAP MaxDB command monitor | Count |
| sap.maxdb.command.monitor.vsuspends | The number of suspends encountered by the SAP MaxDB command monitor | Count |
| sap.maxdb.command.monitor.physical.io.ops | The number of physical I/O operations performed by the executed query | Count |
| sap.maxdb.command.monitor.fetched.rows | The number of rows fetched by the executed query | Count |
| sap.maxdb.command.monitor.runtime.ms | The runtime of the executed query in milliseconds | Count |
| sap.maxdb.command.monitor.fetch.calls | The number of fetch calls made by the executed query | Count |
| sap.maxdb.command.monitor.time.sec | The execution time of the command monitor in seconds | Count |
| sap.maxdb.command.monitor.time | The execution time of the command monitor | String |
| sap.maxdb.cache | The SAP MaxDB cache | String |
| sap.maxdb.cache.unsuccessful.accesses | The number of unsuccessful accesses to the SAP MaxDB cache | Count |
| sap.maxdb.cache.successful.accesses | The number of successful accesses to the SAP MaxDB cache | Count |
| sap.maxdb.cache.accesses | The total number of accesses to the SAP MaxDB cache | Count |
| sap.maxdb.cache.hit.ratio.percent | The hit ratio of the SAP MaxDB cache in percentage | Count |