Extend the platform,
empower your team.
Easily understand the health and performance of your SAP HANA databases.
Extension by DynatraceOur SAP HANA database monitoring solution is based on a remote monitoring approach implemented as a Dynatrace ActiveGate extension. The extension queries SAP HANA databases for key performance and health. Captured metrics include infrastructure measures (CPU, Disk, and Network metrics) as well as details related to Backups, Savepoints, Replication, and more. Dynatrace's DAVIS AI then analyzes these metrics to provide anomaly and problem analysis.
PUBLIC
and MONITORING
rolesngdbc-2.14.7.jar
to this directory on all your ActiveGates in your desired group
C:\ProgramData\dynatrace\remotepluginmodule\agent\conf\userdata\libs
/var/lib/dynatrace/remotepluginmodule/agent/conf/userdata/libs
Then activate the extension in your environment using the in-product Hub, provide the necessary device configuration and you’re all set up.
This extension connects remotely via an ActiveGate to your SAP HANA Database using the credentials provided. It pulls a variety of metrics via the Monitoring Views provided by the database itself.
This is intended for users, who:
This enables you to:
Below is a complete list of the feature sets provided in this version. To ensure a good fit for your needs, individual metrics can be activated and deactivated by your administrator during configuration.
Metric name | Metric key | Description | Unit |
---|---|---|---|
NIC Rate | sap.hana.db.host.network_interface.rate | NIC IO Speeds (both Tx and Rx) | KiloBytePerSecond |
Metric name | Metric key | Description | Unit |
---|---|---|---|
Service Response Time | sap.hana.db.service.response_time | Average Response Time of the Service (Host Process) | MilliSecond |
Metric name | Metric key | Description | Unit |
---|---|---|---|
Secondary Failover Count | sap.hana.db.service.replication.secondary_failover_count.count | Replication - Number of Secondary Failover Count | Count |
Log Shipping Delay | sap.hana.db.service.replication.log_shipping_delay | Replication - Number of seconds between Last Log Position and Shipped Log Position | Second |
Replication Errors | sap.hana.db.service.replication.errors | Replication - Number of Errors | Count |
Replication Snapshot Age | sap.hana.db.service.replication.snapshot_age | Replication - Age in Seconds of most recent Snapshot | Second |
Metric name | Metric key | Description | Unit |
---|---|---|---|
Expensive Statements Exceeding Memory Limit | sap.hana.db.sql.expensive_statements_exceeding_memory_limit.count | Number of Expensive SQL Statements that exceed the configured Memory Limit | Count |
Expensive Statements Exceeding Duration Limit | sap.hana.db.sql.expensive_statements_duration_limit.count | Number of Expensive SQL Statements that exceed the configured Duration Limit | Count |
Metric name | Metric key | Description | Unit |
---|---|---|---|
Table Locks | sap.hana.db.service.table.locks | Number of Locks On a Table | Count |
Record Count | sap.hana.db.service.table.records | Number of Records in a Table | Count |
Table Size | sap.hana.db.service.table.size | Size of a Table | Byte |
Metric name | Metric key | Description | Unit |
---|---|---|---|
Active Statements | sap.hana.db.current_active_prepared_statements | Number of Current Active Prepared Statements | Count |
Metric name | Metric key | Description | Unit |
---|---|---|---|
Backup Count | sap.hana.db.backups | Number of Backups | Count |
Backup Time Since Previous | sap.hana.db.backup.time_since_previous | Seconds since Previous Backup Type was taken. | Second |
Backup Duration | sap.hana.db.backup.duration | How long the different backup type took. | Second |
Failure Count | sap.hana.db.backup.failures.count | Backup Failure Count | Count |
Metric name | Metric key | Description | Unit |
---|---|---|---|
Disk Size Usage | sap.hana.db.disk_size_usage | Ratio of used disk space by DB tables | Percent |
Connection Usage | sap.hana.db.connection_usage | Used Connection Percentage | Percent |
Transaction Usage | sap.hana.db.transaction_usage | Used Transaction Percentage | Percent |
Active Transactions | sap.hana.db.transactions | Number of active transactions | Count |
Disk Size By Schema | sap.hana.db.schema.disk_used_size | Absolute disk usage per schema | Byte |
Disk Usage By Schema | sap.hana.db.schema.total_disk_size_percentage | Relative disk usage per schema | Percent |
Open Connections | sap.hana.db.host.open_connections | Number of Current Connections without an end time, no matter the connection status (RUNNING/IDLE/QUEUING) | Count |
Running Connections | sap.hana.db.host.running_connections | Number of Current Connections in the RUNNING state | Count |
CPU Usage | sap.hana.db.host.cpu | Host CPU Usage | Percent |
Disk Used | sap.hana.db.host.disk_used | Host Disk Usage | Byte |
Disk IO Read Speed | sap.hana.db.host.disk_io_read_speed | Disk IO Read Speed | MegaBytePerSecond |
Disk IO Write Speed | sap.hana.db.host.disk_io_write_speed | Disk IO Write Speed | MegaBytePerSecond |
Metric name | Metric key | Description | Unit |
---|---|---|---|
Savepoints Count | sap.hana.db.service.savepoints.count | Number of Savepoints | Count |
Savepoint Critical Phase Duration | sap.hana.db.service.savepoint_critical_phase_duration | Duration of Critical Phase in Savepoint creation | Second |
Savepoint Time Since Previous | sap.hana.db.service.savepoint_time_since_previous | Time since Previous Savepoint | Second |
Metric name | Metric key | Description | Unit |
---|---|---|---|
SQL Plan Cache Size | sap.hana.db.current_sql_plan_cache_size | Current Number of SQL Plans in Cache | Count |
Metric name | Metric key | Description | Unit |
---|---|---|---|
Low Memory Unloads | sap.hana.db.service.low_memory_unloads.count | Number of Unloads due to Low Memory | Count |
DXS-385 :
sap.hana.db.service.volume.used
, sap.hana.db.service.volume.total
, and func:sap.hana.db.service.volume.usage
Volume Metricssap.hana.db.service.table.locks
, sap.hana.db.service.table.records
, and sap.hana.db.service.table.size
Table Metrics
schema_name_filter
and table_name_filter
, this requires recreating the monitoring configurations hence the major version update.DXS-494 :
sap.hana.db.current_active_prepared_statements
and sap.hana.db.current_sql_plan_cache_size
MetricsDXS-613 :
sap.hana.db.host.network_interface.rate
Metric
SYS.M_HOST_AGENT_METRICS
table does not existsap.hana.db.service.cpu_usage
is kept as part of Default Feature Setsap.hana.db.service.response_time
is now a part of the new "Service Response Time" Feature Set
RESPONSE_TIME
column does not exist in tableSYS.M_SERVICE_STATISTICS
sap.hana.db.license.limit
now shows a -1 if there is no PRODUCT_LIMIT
column in the M_LICENSE
viewAdditional New Metrics & Changes :
sap.hana.db.host.open_connections
Metric
sap.hana.db.host.running_connections
sap.hana.db.transactions
sap.hana.db.tracefiles
sap.hana.db.backups
sap.hana.db.backup.size
sap.hana.db.disk_size_usage
sap.hana.db.transaction_usage
sap.hana.db.connection_usage
sap.hana.db.schema.disk_used_size
sap.hana.db.schema.total_disk_size_percentage
sap.hana.db.limits
- Max Sessions & Transactionssap.hana.db.service.system_cpu_usage
- indexserver and nameserver onlyFix for EXT-5079: SAP Hana DB extension 2.0 restarts continuously due to missing data.
Current Alerts
& Expensive Statements
_SYS_STATISTICS.STATISTICS_CURRENT_ALERTS
and SYS.M_EXPENSIVE_STATEMENTS
respectively.sql:hana_db_database
)sql:hana_db_service
)sql:hana_db_host
)SAP HANA DB Overview