Extend the platform,
empower your team.
Easily understand the health and performance of your SAP HANA databases.
ExtensionOur 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.
This is intended for users, who:
This enables you to:
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.
Starting with v2.0.0 the feature set Table Information
was added.
This feature set is enabled by default for new monitoring configurations. Due to the nature of the metrics listed below, this can cause high licensing costs to be incurred.
sap.hana.db.service.table.locks
sap.hana.db.service.table.records
sap.hana.db.service.table.size
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.
A: The formula for consumption of the extension is:
Per Database & Host:
Logs :
Out Of Memory Events -> Each event is ingested as a log message
Trace File Information -> Each tracefile is ingested as a log message
Current Alerts -> Each Current Alert is ingested as a log message
Expensive Statements - Each Expensive Statement is ingested as a log message
Metrics :
(40 + (2 * <# of Schemas>) + (14 * <# of Services>) + (3 * <# of Schemas> * <Avg # of Tables per Schema>))
NOTE: The # of Services is usually around 9. This includes processes like the compileserver, indexserver, nameserver, webdispatcher, and xs* processes
Below is a complete list of the feature sets provided in this version. To ensure a good fit for your needs, individual feature sets can be activated and deactivated by your administrator during configuration.
Metric name | Metric key | Description | Unit |
---|---|---|---|
Tracefile Count | sap.hana.db.tracefiles | Number of diagnostic files | Count |
HANA Database Limits | sap.hana.db.limits | Database Limits | Count |
Limit | sap.hana.db.license.limit | License Information including Licensed Size in GB | GigaByte |
HANA DB Build Version | sap.hana.db.build_version | SAP HANA DB Build Version | Count |
IP Addresses | sap.hana.db.ip_addresses | IP Address of HANA DB Host | Count |
Max Heap Usage | sap.hana.db.host.max_heap_usage | Max Heap Usage of the Host | Byte |
Global Memory Allocation Limit | sap.hana.db.host.global_memory_allocation_limit | Global Memory Allocation Limit | Byte |
Used Memory | sap.hana.db.host.used_memory | Host Used Memory | Byte |
Used Physical Memory | sap.hana.db.host.used_physical_memory | Host Used Physical Memory | Byte |
Volume Used Size | sap.hana.db.service.volume.used | Used Size of Volume | Byte |
Total Volume Size | sap.hana.db.service.volume.total | Total Size of Volume | Byte |
Service Memory Used | sap.hana.db.service.memory.used | Memory Usage of the Service (Host Process) | Byte |
Service Column Tables Memory Used | sap.hana.db.service.memory.column_tables_memory_used | Column Tables Memory Usage by Service | Byte |
Service Row Store Allocated Size | sap.hana.db.service.memory.row_store_allocated_size | Row Store Allocated Size by Service | Byte |
System CPU Usage | sap.hana.db.service.system_cpu_usage | Rate of OS Kernel/System CPU used by index server | Percent |
Service CPU Usage | sap.hana.db.service.cpu_usage | Service CPU Usage | Percent |
Service Status | sap.hana.db.service.status | Current Service Status | Count |
Service Max Merge Dog Thread Duration | sap.hana.db.service.max_merge_dog_thread_duration | Max Duration of the Merge Dog Thread | Second |
Blocked Transactions | sap.hana.db.service.blocked_transactions | Number of Blocked Transactions | Count |
Current Transaction Locks | sap.hana.db.service.current_transaction_locks | Number of current transaction locks | Count |
Service Threads | sap.hana.db.service.threads | Number of Threads By Type | Count |
Minimum SQL Plan Cache Hit Ratio | sap.hana.db.sql.min_sql_plan_cache_hit_ratio | Minimum SQL Plan Cache Hit Percentage | Percent |
Metric name | Metric key | Description | Unit |
---|---|---|---|
Backup Count | sap.hana.db.backups | Number of Backups | Count |
Backup Size | sap.hana.db.backup.size | Estimated backup size | Byte |
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 |
---|---|---|---|
Heap Temp Memory Usage | sap.hana.db.host.heap_temp_memory_usage | Heap - Temporary Memory Usage | Byte |
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 |
---|---|---|---|
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 |
Expensive Statements Exceeding Memory Limit | sap.hana.db.sql.expensive_statements_exceeding_memory_limit | 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 | Number of Expensive SQL Statements that exceed the configured Duration Limit | Count |
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 |
---|---|---|---|
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 |
---|---|---|---|
Total Expensive Statements | sap.hana.db.sql.total_expensive_statements | Total Number of Expensive SQL Statements | Count |
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 |
---|---|---|---|
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 |
---|---|---|---|
Low Memory Unloads | sap.hana.db.service.low_memory_unloads.count | Number of Unloads due to Low Memory | 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 |
---|---|---|---|
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 |
---|---|---|---|
NIC Rate | sap.hana.db.host.network_interface.rate | NIC IO Speeds (both Tx and Rx) | KiloBytePerSecond |
custom_host
dimension to all metricsAdded database
as attribute to Out Of Memory Events Log Messages
Added existing timeout variable to additional subgroups to help long running queries
DXS-1270 - ( delta/count based Expensive Statement metrics may stop working as expected if the SYS.M_EXPENSIVE_STATEMENTS
hits the table records limit)
sap.hana.db.sql.total_expensive_statements
Metric in "Expensive Statement Metrics" Feature Setsap.hana.db.sql.expensive_statements_exceeding_memory_limit.count
sap.hana.db.sql.expensive_statements_duration_limit.count
sap.hana.db.sql.expensive_statements_exceeding_memory_limit
sap.hana.db.sql.expensive_statements_duration_limit
license
query to correct single-row query returns more than one row
exceptionOut Of Memory Events
, Trace File Information
, & Expensive Statements
Feature Sets) from using CURRENT_UTCTIMESTAMP function to CURRENT_TIMESTAMP.Backup Metrics
- specifically the sap.hana.db.backup.size
metric Host Temp Heap Usage
- specifically the sap.hana.db.host.heap_temp_memory_usage
metricDXS-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