SAP HANA Database (remote monitoring) extension

  • Latest Dynatrace
  • Extension
  • Published Oct 27, 2025

Understand the health and performance of your SAP HANA databases.

Get started

Overview

Monitor SAP HANA databases remotely to analyze SQL and database health in SAP.

Our 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 Davis AI then analyzes these metrics to provide anomaly and problem analysis.

Use cases

  • Monitor the health state and performance of their SAP HANA Databases.
  • Monitor infrastructure with a comprehensive dashboard
  • Detect traffic anomalies and alert on them
  • Take pre-emptive measures to avoid service degradations

Requirements

<!- To review with SME: It should include ActiveGate–>

  • A SAP HANA database user with the PUBLIC and MONITORING roles
    • For Audit Log Monitoring via the Audit Logs Feature Set, GRANT AUDIT READ TO <USER> is needed.
  • SAP HANA DB JDBC Driver downloaded from here
    • Copy ngdbc-2.14.7.jar to this directory on all your ActiveGates in your desired group
      • Windows : C:\ProgramData\dynatrace\remotepluginmodule\agent\conf\userdata\libs
      • Linux : /var/lib/dynatrace/remotepluginmodule/agent/conf/userdata/libs
    • NOTE: These are the default directories and may be different depending how the ActiveGate installation was done and if it was customized.

Activation and setup

Activate the extension in your environment using the in-product Hub. Provide the necessary device configuration and you’re all set up.

Starting with version 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

Details

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.

Licensing and cost

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

DQL and Logs

The following are individually ingestested as a log message:

  • Out Of Memory Events
  • Tracefile Information
  • Current Alerts
  • Expensive Statements

Feature sets

When activating your extension using monitoring configuration, you can limit monitoring to one of the feature sets. To work properly the extension has to collect at least one metric after the activation.

In highly segmented networks, feature sets can reflect the segments of your environment. Then, when you create a monitoring configuration, you can select a feature set and a corresponding ActiveGate group that can connect to this particular segment.

All metrics that aren't categorized into any feature set are considered to be the default and are always reported.

A metric inherits the feature set of a subgroup, which in turn inherits the feature set of a group. Also, the feature set defined on the metric level overrides the feature set defined on the subgroup level, which in turn overrides the feature set defined on the group level.

HANA License
Metric nameMetric keyDescription
Limitsap.hana.db.license.limitLicense Information including Licensed Size in GB
Schema Disk Metrics
Metric nameMetric keyDescription
Disk Size By Schemasap.hana.db.schema.disk_used_sizeAbsolute disk usage per schema
Disk Usage By Schemasap.hana.db.schema.total_disk_size_percentageRelative disk usage per schema
Expensive Statements
Metric nameMetric keyDescription
Base Metrics
Metric nameMetric keyDescription
Tracefile Countsap.hana.db.tracefilesNumber of diagnostic files
Service Max Merge Dog Thread Durationsap.hana.db.service.max_merge_dog_thread_durationMax Duration of the Merge Dog Thread
Blocked Transactionssap.hana.db.service.blocked_transactionsNumber of Blocked Transactions
Current Transaction Lockssap.hana.db.service.current_transaction_locksNumber of current transaction locks
Minimum SQL Plan Cache Hit Ratiosap.hana.db.sql.min_sql_plan_cache_hit_ratioMinimum SQL Plan Cache Hit Percentage
Current Alerts
Metric nameMetric keyDescription
Unloads Due to Low Memory
Metric nameMetric keyDescription
Low Memory Unloadssap.hana.db.service.low_memory_unloads.countNumber of Unloads due to Low Memory
SQL Plan Cache Size
Metric nameMetric keyDescription
SQL Plan Cache Sizesap.hana.db.current_sql_plan_cache_sizeCurrent Number of SQL Plans in Cache
Out Of Memory Events
Metric nameMetric keyDescription
Expensive Statement Metrics
Metric nameMetric keyDescription
Total Expensive Statementssap.hana.db.sql.total_expensive_statementsTotal Number of Expensive SQL Statements
Host Temp Heap Usage
Metric nameMetric keyDescription
Heap Temp Memory Usagesap.hana.db.host.heap_temp_memory_usageHeap - Temporary Memory Usage
Audit Logs
Metric nameMetric keyDescription
Savepoint Metrics
Metric nameMetric keyDescription
Savepoints Countsap.hana.db.service.savepoints.countNumber of Savepoints
Savepoint Critical Phase Durationsap.hana.db.service.savepoint_critical_phase_durationDuration of Critical Phase in Savepoint creation
Savepoint Time Since Previoussap.hana.db.service.savepoint_time_since_previousTime since Previous Savepoint
Active Prepared Statements
Metric nameMetric keyDescription
Active Statementssap.hana.db.current_active_prepared_statementsNumber of Current Active Prepared Statements
Backup Metrics
Metric nameMetric keyDescription
Backup Countsap.hana.db.backupsNumber of Backups
Backup Sizesap.hana.db.backup.sizeEstimated backup size
Backup Time Since Previoussap.hana.db.backup.time_since_previousSeconds since Previous Backup Type was taken.
Backup Durationsap.hana.db.backup.durationHow long the different backup type took.
Failure Countsap.hana.db.backup.failures.countBackup Failure Count
Table Information
Metric nameMetric keyDescription
Table Lockssap.hana.db.service.table.locksNumber of Locks On a Table
Record Countsap.hana.db.service.table.recordsNumber of Records in a Table
Table Sizesap.hana.db.service.table.sizeSize of a Table
Trace File Information
Metric nameMetric keyDescription
Replication Metrics
Metric nameMetric keyDescription
Secondary Failover Countsap.hana.db.service.replication.secondary_failover_count.countReplication - Number of Secondary Failover Count
Log Shipping Delaysap.hana.db.service.replication.log_shipping_delayReplication - Number of seconds between Last Log Position and Shipped Log Position
Replication Errorssap.hana.db.service.replication.errorsReplication - Number of Errors
Replication Snapshot Agesap.hana.db.service.replication.snapshot_ageReplication - Age in Seconds of most recent Snapshot
Host Agent Network Rates
Metric nameMetric keyDescription
NIC Ratesap.hana.db.host.network_interface.rateNIC IO Speeds (both Tx and Rx)
default
Metric nameMetric keyDescription
HANA Database Limitssap.hana.db.limitsDatabase Limits
HANA DB Build Versionsap.hana.db.build_versionSAP HANA DB Build Version
IP Addressessap.hana.db.ip_addressesIP Address of HANA DB Host
Max Heap Usagesap.hana.db.host.max_heap_usageMax Heap Usage of the Host
Global Memory Allocation Limitsap.hana.db.host.global_memory_allocation_limitGlobal Memory Allocation Limit
Used Memorysap.hana.db.host.used_memoryHost Used Memory
Used Physical Memorysap.hana.db.host.used_physical_memoryHost Used Physical Memory
Volume Used Sizesap.hana.db.service.volume.usedUsed Size of Volume
Total Volume Sizesap.hana.db.service.volume.totalTotal Size of Volume
Service Memory Usedsap.hana.db.service.memory.usedMemory Usage of the Service (Host Process)
Service Column Tables Memory Usedsap.hana.db.service.memory.column_tables_memory_usedColumn Tables Memory Usage by Service
Service Row Store Allocated Sizesap.hana.db.service.memory.row_store_allocated_sizeRow Store Allocated Size by Service
System CPU Usagesap.hana.db.service.system_cpu_usageRate of OS Kernel/System CPU used by index server
Service CPU Usagesap.hana.db.service.cpu_usageService CPU Usage
Service Statussap.hana.db.service.statusCurrent Service Status
Service Threadssap.hana.db.service.threadsNumber of Threads By Type
Disk Size Usage
Metric nameMetric keyDescription
Disk Usagesap.hana.db.host.disk_usageHost Disk Usage
Service Response Time
Metric nameMetric keyDescription
Service Response Timesap.hana.db.service.response_timeAverage Response Time of the Service (Host Process)
Host Infrastructure Metrics
Metric nameMetric keyDescription
Connection Usagesap.hana.db.connection_usageUsed Connection Percentage
Transaction Usagesap.hana.db.transaction_usageUsed Transaction Percentage
Active Transactionssap.hana.db.transactionsNumber of active transactions
Open Connectionssap.hana.db.host.open_connectionsNumber of Current Connections without an end time, no matter the connection status (RUNNING/IDLE/QUEUING)
Running Connectionssap.hana.db.host.running_connectionsNumber of Current Connections in the RUNNING state
Memory Usedsap.hana.db.host.memory_usedHost Memory Used
Memory Sizesap.hana.db.host.memory_sizeHost Memory Size
Memory Usagesap.hana.db.host.memory_usageHost Memory Usage
CPU Usagesap.hana.db.host.cpuHost CPU Usage
Disk Usedsap.hana.db.host.disk_usedHost Disk Used
Disk Sizesap.hana.db.host.disk_sizeHost Disk Size
Disk IO Read Speedsap.hana.db.host.disk_io_read_speedDisk IO Read Speed
Disk IO Write Speedsap.hana.db.host.disk_io_write_speedDisk IO Write Speed
Host Infrastructure Network Rates
Metric nameMetric keyDescription
Network Insap.hana.db.host.network_inHost Network In
Network Outsap.hana.db.host.network_outHost Network Out
Extended Expensive Statement Metrics
Metric nameMetric keyDescription
Expensive Statements Exceeding Memory Limitsap.hana.db.sql.expensive_statements_exceeding_memory_limit.countNumber of Expensive SQL Statements that exceed the configured Memory Limit
Expensive Statements Exceeding Duration Limitsap.hana.db.sql.expensive_statements_duration_limit.countNumber of Expensive SQL Statements that exceed the configured Duration Limit
Expensive Statements Exceeding Memory Limitsap.hana.db.sql.expensive_statements_exceeding_memory_limitNumber of Expensive SQL Statements that exceed the configured Memory Limit
Expensive Statements Exceeding Duration Limitsap.hana.db.sql.expensive_statements_duration_limitNumber of Expensive SQL Statements that exceed the configured Duration Limit
Table Size vs Allocation Limit Usage
Metric nameMetric keyDescription
Table Size vs Allocated Limit Ratiosap.hana.db.total_table_size_vs_allocation_limit_ratioRatio of used disk space by DB tables vs the Allocated Limit

FAQ

What is the Custom Metric Usage of this extension?

The formula for consumption of the extension is

Per Database & Host: 56 + Schema Disk Metrics Feature Set + Table Information Feature Set + (6 * <# of Services>)

Where

  • Schema Disk Metrics Feature Set = 2 * <# of Schemas>
  • Table Information Feature Set = 3 * <# of Schemas> * <Avg # of Tables per Schema>
  • The # of Services is usually around 9. This includes processes like the compileserver, indexserver, nameserver, webdispatcher, and xs* processes.
Hub

Explore in Dynatrace Hub

Understand the health and performance of your SAP HANA databases.

Related tags
DatabaseSQLSQLSAPApplication Observability