SAP HANA
Overview
SAP HANA, the powerful in-memory data platform developed by SAP, 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 HANA databases and applications. Monitor critical database metrics such as query response times, data consumption rates, and memory usage to ensure efficient data processing and analysis.
Supported Versions
| Versions |
|---|
| 1.0 |
| 2.0 |
| 2.00.040.00.1553674765 (fa/hana2sp04) |
Prerequisites for SAP HANA Integration with Motadata AIOps:
Ensure that the SAP HANA port (default: 30015) 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 HANA database.
Ensure that JDBC is supported on the server where SAP HANA Database is configured.
For agentless monitoring, ensure that the user has the required access for remote access to the SAP HANA server. For agent-based monitoring, this is not required.
Ensure that the SAP HANA service is active and running on the server.
Ensure you have the name of the SAP HANA database that you want to monitor.
Confirm that the SAP HANA 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 HANA version that you intend to monitor.
By following these prerequisites, you can integrate SAP HANA with Motadata AIOps and ensure smooth functioning of the monitoring process.
List of Supported KPIs
| Name | Description | Type |
|---|---|---|
| sap.hana.database | SAP HANA Database | String |
| sap.hana.database.description | Description of the SAP HANA Database | String |
| sap.hana.database.status | Status of the SAP HANA Database | String |
| sap.hana.schema | SAP HANA Schema | String |
| sap.hana.schema.size.bytes | Size of the SAP HANA Schema in bytes | Count |
| sap.hana.schema.tables | Number of tables in the SAP HANA Schema | Count |
| sap.hana.cache.used.bytes | Used cache size in bytes | Count |
| sap.hana.cache.hits | Number of cache hits | Count |
| sap.hana.cache.host | Host of the SAP HANA cache | String |
| sap.hana.cache.misses | Number of cache misses | Count |
| sap.hana.cache.hit.ratio.percent | Cache hit ratio percentage | Count |
| sap.hana.cache.size.bytes | Size of the SAP HANA cache in bytes | Count |
| sap.hana.cache | SAP HANA Cache | String |
| system.tags | System tags | String |
| started.time.sec | Uptime in seconds | Count |
| started.time | Uptime | String |
| sap.hana.license.size.gb | Size of the SAP HANA license in gigabytes | Count |
| sap.hana.license.used.gb | The amount of SAP HANA license capacity currently in use, in gigabytes. | Count |
| sap.hana.license.usable.gb | The available usable SAP HANA license capacity, in gigabytes. | Count |
| sap.hana.license.used.percent | The percentage of SAP HANA license capacity being utilized. | Count |
| sap.hana.instance.id | The unique identifier of the SAP HANA instance. | String |
| sap.hana.instance.number | The number associated with the SAP HANA instance. | Count |
| sap.hana.system.type | The type of the SAP HANA system. | String |
| sap.hana.version | The version of SAP HANA being used. | String |
| sap.hana.platform | The platform on which SAP HANA is deployed. | String |
| sap.hana.memory.used.percent | The percentage of SAP HANA memory being utilized. | Count |
| sap.hana.memory.provisioned.bytes | The total provisioned memory for SAP HANA, measured in bytes. | Count |
| sap.hana.swap.memory.bytes | The amount of swap memory allocated for SAP HANA, measured in bytes. | Count |
| sap.hana.memory.used.bytes | The amount of memory currently in use by SAP HANA, measured in bytes. | Count |
| sap.hana.processor.utilization.percent | The percentage of CPU utilization by SAP HANA. | Count |
| sap.hana.available.processors | The number of available processors or CPU cores in SAP HANA. | Count |
| sap.hana.used.processors | The number of processors or CPU cores being utilized by SAP HANA. | Count |
| sap.hana.expensive.query.host | The host where the expensive query was executed. | String |
| sap.hana.expensive.query.id | The unique identifier of the expensive query. | String |
| sap.hana.expensive.query.connection.id | The connection ID associated with the expensive query. | String |
| sap.hana.expensive.query.duration.ms | The duration of the expensive query execution in milliseconds. | Count |
| sap.hana.expensive.query.records | The number of records processed by the expensive query. | Count |
| sap.hana.expensive.query.memory.bytes | The memory consumed by the expensive query in bytes. | Count |
| sap.hana.expensive.query.cpu.time.ms | The CPU time taken by the expensive query in milliseconds. | String |
| sap.hana.expensive.query.db.user | The database user associated with the expensive query. | String |
| sap.hana.expensive.query.operation | The operation performed by the expensive query. | String |
| sap.hana.expensive.query.text | The SQL text of the expensive query. | String |
| sap.hana.expensive.query.error.code | The error code associated with the expensive query. | Count |
| sap.hana.expensive.query.error | The error message, if any, encountered during the query execution. | String |
| sap.hana.job.host | The host where the job is running. | String |
| sap.hana.job.connection.id | The connection ID associated with the job. | String |
| sap.hana.job.start.time | The start time of the job. | String |
| sap.hana.job.name | The name of the job. | String |
| sap.hana.job.schema.name | The schema name associated with the job. | String |
| sap.hana.job.current.progress | The current progress/status of the job. | String |
| sap.hana.blocked.transaction.id | The ID of the blocked transaction. | Count |
| sap.hana.blocking.transaction | The number of blocking transactions. | Count |
| sap.hana.blocked.time | The duration for which the transaction is blocked. | String |
| sap.hana.blocked.schema | The schema associated with the blocked transaction. | String |
| sap.hana.blocked.object.name | The name of the blocked object. | String |
| sap.hana.blocking.lock.type | The type of lock causing the blocking. | String |
| sap.hana.blocking.lock.mode | The lock mode of the blocking lock. | String |
| sap.hana.blocked.query | The query being executed by the blocked transaction. | String |
| sap.hana.active.transactions | The number of active transactions in SAP HANA. | Count |
| sap.hana.inactive.transactions | The number of inactive transactions in SAP HANA. | Count |
| sap.hana.idle.transactions | The number of idle transactions in SAP HANA. | Count |
| sap.hana.blocked.transactions | The number of blocked transactions in SAP HANA. | Count |
| correlation.metrics | The count of correlation metrics. | Count |
| sap.hana.session.host | The host of the SAP HANA session. | String |
| sap.hana.session.port | The port of the SAP HANA session. | Count |
| sap.hana.session.connection.id | The ID of the SAP HANA session connection. | Count |
| sap.hana.session.connection.status | The status of the SAP HANA session connection. | String |
| sap.hana.session.connection.type | The type of the SAP HANA session connection. | String |
| sap.hana.session.transaction.id | The ID of the transaction associated with the session. | Count |
| sap.hana.session.idle.time.ms | The idle time in milliseconds for the session. | Count |
| sap.hana.session.auto.commit | Indicates whether auto-commit is enabled for the session. | String |
| sap.hana.session.user.name | The name of the user associated with the session. | String |
| sap.hana.session.fetched.records | The count of records fetched by the session. | Count |
| sap.hana.session.current.schema.name | The name of the current schema for the session. | String |
| sap.hana.session.sent.bytes | The number of bytes sent by the session. | Count |
| sap.hana.session.sent.messages | The number of messages sent by the session. | Count |
| sap.hana.session.remote.client | The client associated with the remote session. | String |
| sap.hana.session.client.pid | The process ID (PID) of the client application. | Count |
| sap.hana.session.query | The count of queries executed by the session. | Count |
| sap.hana.active.connections | The number of active connections to SAP HANA. | Count |
| sap.hana.idle.connections | The number of idle connections to SAP HANA. | Count |
| sap.hana.queued.connections | The number of queued connections to SAP HANA. | Count |
| sap.hana.session | The number of active sessions in SAP HANA. | Count |
| correlation.metrics | The count of correlation metrics. | Count |
| sap.hana.service | The SAP HANA service. | String |
| sap.hana.service.host | The host of the SAP HANA service. | String |
| sap.hana.service.status | The status of the SAP HANA service. | String |
| sap.hana.service.port | The port of the SAP HANA service. | String |
| sap.hana.service.logical.memory.size.bytes | The size of logical memory used by the service. | Count |
| sap.hana.service.memory.used.bytes | The amount of memory used by the service. | Count |
| sap.hana.service.heap.memory.bytes | The size of the heap memory used by the service. | Count |
| sap.hana.service.heap.memory.used.bytes | The amount of heap memory used by the service. | Count |
| sap.hana.service.shared.memory.bytes | The size of shared memory used by the service. | Count |
| sap.hana.service.shared.memory.used.bytes | The amount of shared memory used by the service. | Count |
| sap.hana.service.compactor.allocated.memory.bytes | The amount of memory allocated by the compactor. | Count |
| sap.hana.service.compactor.memory.freeable.bytes | The amount of freeable memory managed by the compactor. | Count |
| sap.hana.service.coordinator.type | The type of the service coordinator. | String |
| sap.hana.service.cpu.percent | The CPU usage percentage of the service. | Count |
| sap.hana.service.opened.files | The number of opened files by the service. | Count |
| sap.hana.service.active.threads | The number of active threads in the service. | Count |
| sap.hana.service.memory.bytes | The total amount of memory used by the service. | Count |
| sap.hana.service.request.latency.time.ms | The latency time of requests processed by the service. | Count |
| sap.hana.service.active.requests | The number of active requests handled by the service. | Count |
| sap.hana.service.requests.per.sec | The rate of requests processed per second by the service. | Count |
| sap.hana.service.pending.requests | The number of pending requests in the service. | Count |
| sap.hana.service.memory.provisioned.bytes | The provisioned memory size for the service. | Count |
| sap.hana.host | Host name of the SAP HANA service | String |
| sap.hana.host.memory.provisioned.bytes | Total provisioned memory on the SAP HANA host | Count |
| sap.hana.host.memory.used.bytes | Memory used on the SAP HANA host | Count |
| sap.hana.host.memory.free.bytes | Free memory available on the SAP HANA host | Count |
| sap.hana.host.allocation.limit.bytes | Memory allocation limit on the SAP HANA host | Count |
| sap.hana.host.swap.memory.bytes | Total swap memory on the SAP HANA host | Count |
| sap.hana.host.swap.memory.used.bytes | Swap memory used on the SAP HANA host | Count |
| sap.hana.host.swap.memory.free.bytes | Free swap memory available on the SAP HANA host | Count |
| sap.hana.host.memory.used.percent | Percentage of memory used on the SAP HANA host | Count |
| sap.hana.host.swap.memory.used.percent | Percentage of swap memory used on the SAP HANA host | Count |
| sap.hana.host.service.memory.bytes | Memory used by services on the SAP HANA host | Count |
| sap.hana.host.code.stack.bytes | Memory used by code stack on the SAP HANA host | Count |
| sap.hana.host.table.column.bytes | Memory used by table columns on the SAP HANA host | Count |
| sap.hana.host.table.row.bytes | Memory used by table rows on the SAP HANA host | Count |
| sap.hana.host.instance.memory.used.bytes | Memory used by HANA instance(s) on the SAP HANA host | Count |
| sap.hana.host.peak.memory.used.bytes (random) | Peak memory used by the SAP HANA host | Count |
| sap.hana.host.executions.per.sec | Executions per second on the SAP HANA host | Count |
| sap.hana.host.compilations.per.sec | Compilations per second on the SAP HANA host | Count |
| sap.hana.host.memory.bytes.per.sec | Memory consumption rate on the SAP HANA host | Count |
| sap.hana.host.commits.per.sec | Commits per second on the SAP HANA host | Count |
| sap.hana.host.transactions.per.sec | Transactions per second on the SAP HANA host | Count |
| sap.hana.host.rollbacks.per.sec | Rollbacks per second on the SAP HANA host | Count |
| sap.hana.disk | Metric representing SAP HANA disk | Count |
| sap.hana.disk.path | Path of the SAP HANA disk | String |
| sap.hana.disk.type | Type of the SAP HANA disk | String |
| sap.hana.disk.host | Host of the SAP HANA disk | String |
| sap.hana.disk.bytes | Total bytes of the SAP HANA disk | Count |
| sap.hana.disk.used.bytes | Used bytes of the SAP HANA disk | Count |
| sap.hana.disk.data.volume.bytes | Bytes used by data volume on the SAP HANA disk | Count |
| sap.hana.disk.used.percent | Percentage of used space on the SAP HANA disk | Count |
| sap.hana.disk.free.percent | Percentage of free space on the SAP HANA disk | Count |
| sap.hana.volume.host | Host of the SAP HANA volume | String |
| sap.hana.volume.io.read.bytes | Total bytes read from the SAP HANA volume | Count |
| sap.hana.volume.io.write.bytes | Total bytes written to the SAP HANA volume | Count |
| sap.hana.volume.io.failed.reads | Number of failed read operations on the SAP HANA volume | Count |
| sap.hana.volume.io.reads | Total number of read operations on the SAP HANA volume | Count |
| sap.hana.volume.io.read.time.ms | Total time spent on read operations on the SAP HANA volume (ms) | Count |
| sap.hana.volume.io.time.ms | Total time spent on I/O operations on the SAP HANA volume (ms) | Count |
| sap.hana.volume.io.writes | Total number of write operations on the SAP HANA volume | Count |
| sap.hana.volume.io.bytes.per.sec | Average I/O bytes per second on the SAP HANA volume | Count |
| sap.hana.volume.io.blocked.write.requests | Number of blocked write requests on the SAP HANA volume | Count |
| sap.hana.volume.id | ID of the SAP HANA volume | Count |
| sap.hana.volume.type | Type of the SAP HANA volume | String |
| sap.hana.volume.io.failed.writes | Number of failed write operations on the SAP HANA volume | Count |
| sap.hana.volume.io.appends | Total number of append operations on the SAP HANA volume | Count |
| sap.hana.volume | Metric representing SAP HANA volume | String |
| sap.hana.volume.io.write.time.ms | Total time spent on write operations on the SAP HANA volume (ms) | Count |
| sap.hana.log.replay.queue | Metric representing SAP HANA log replay queue | Count |
| sap.hana.log.replay.volume | Metric representing SAP HANA log replay volume | Count |
| sap.hana.log.replay.queue.host | Host of the SAP HANA log replay queue | String |
| sap.hana.log.replay.queue.record.type | Record type of the SAP HANA log replay queue | String |
| sap.hana.log.replay.queue.records | Number of records in the SAP HANA log replay queue | Count |
| sap.hana.log.replay.queue.latency.time.ms | Latency time in milliseconds of the SAP HANA log replay queue | Count |
| sap.hana.log.replay.queue.wait.time.ms | Wait time in milliseconds of the SAP HANA log replay queue | Count |
| sap.hana.log.replay.queue.record.size.bytes | Size of each record in bytes in the SAP HANA log replay queue | Count |
| sap.hana.replication.site.name | Name of the SAP HANA replication site | String |
| sap.hana.replication.secondary.host | Host of the secondary SAP HANA replication | String |
| sap.hana.replication.secondary.site.name | Name of the secondary SAP HANA replication site | String |
| sap.hana.replication.status | Status of the SAP HANA replication | String |
| sap.hana.replication | Metric representing SAP HANA replication | String |
| sap.hana.backup.catalog | Metric representing SAP HANA backup catalog | Count |
| sap.hana.backup.catalog.source.type | Type of the source for SAP HANA backup catalog | String |
| sap.hana.backup.catalog.service.type.name | Name of the service type for SAP HANA backup catalog | String |
| sap.hana.backup.catalog.start.time | Start time of SAP HANA backup catalog | String |
| sap.hana.backup.catalog.end.time | End time of SAP HANA backup catalog | String |
| sap.hana.backup.catalog.entry.type | Type of entry in SAP HANA backup catalog | String |
| sap.hana.backup.catalog.state | State of SAP HANA backup catalog | String |
| sap.hana.backup.catalog.bytes | Size of SAP HANA backup catalog in bytes | Count |
| sap.hana.latest.backup.id | ID of the latest SAP HANA backup | String |
| sap.hana.latest.backup.start.time | Start time of the latest SAP HANA backup | String |
| sap.hana.latest.backup.end.time | End time of the latest SAP HANA backup | String |
| sap.hana.latest.backup.entry.type | Type of entry in the latest SAP HANA backup | String |
| sap.hana.latest.backup.destination.type | Destination type of the latest SAP HANA backup | String |
| sap.hana.latest.backup.bytes | Size of the latest SAP HANA backup in bytes | Count |
| sap.hana.backup.max.recovery.file.age.sec | Maximum age of recovery files in seconds for SAP HANA backup | Count |
| sap.hana.backup.log.replay.step.bytes | Size of each log replay step in bytes for SAP HANA backup | Count |
| sap.hana.backup.max.recovery.backint.channels | Maximum number of backint channels for recovery in SAP HANA backup | Count |
| sap.hana.backup.backint.executable.link | Link to the backint executable for SAP HANA backup | String |
| sap.hana.backup.backint.executable | Backint executable for SAP HANA backup | String |
| sap.hana.backup.backint.data.path | Data path for SAP HANA backup using backint | String |
| sap.hana.backup.data.file.path | File path for SAP HANA backup data files | String |
| sap.hana.backup.log.file.path | File path for SAP HANA backup log files | String |