SAP HANA Database (remote monitoring) extension

  • Latest Dynatrace
  • Extension

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

View everything in one place via the SAP HANA DB Overview dashboard.See all your databases listed in an easy to filter page.See a detailed view of your database with it's metrics and properties.See a detailed view of your database hosts with it's metrics and properties.See a detailed view of the services (processes) supporting your database with it's metrics and properties.Easily configure all your databases in one or multiple monitoring configurations!
1 of 6View everything in one place via the SAP HANA DB Overview dashboard.

Get started

Overview

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

The SAP HANA database monitoring solution is implemented as a Dynatrace ActiveGate extension. The extension queries SAP HANA databases for key performance and health metrics, including infrastructure metrics (CPU, Disk, and Network) as well as details on Backups, Savepoints, Replication, and more. Dynatrace Intelligence analyzes these metrics for anomalies and problems.

Use cases

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

Requirements

  • Designate an ActiveGate group or groups that will remotely connect to your SAP Hana Database server to pull data. All ActiveGates in each group must connect to your SAP HANA database.

  • Download and select SAP HANA DB JDBC driver from Maven Repository.

    Add JDBC driver

    Manually place the driver JAR file on the ActiveGate host.

    To define the SAP HANA Database server, put ngdbc.jar file in the following location:

    Windows: C:\ProgramData\dynatrace\remotepluginmodule\agent\conf\userdata\libs
    Linux: /var/lib/dynatrace/remotepluginmodule/agent/conf/userdata/libs/

    These are the default directories. The actual location may differ based on your ActiveGate installation and customization.

    Where to find the ngdbc.jar file

    You can obtain the ngdbc.jar file from the SAP HANA Client installation directory:

    • Windows: C:\Program Files\SAP\hdbclient\ngdbc.jar
    • Linux: /usr/sap/hdbclient/ngdbc.jar

  • Create a dedicated database user in your database instance with necessary permissions. Dynatrace uses this user to run monitoring queries against your SAP HANA database.

    • Assign PUBLIC and MONITORING roles to the user.
    • To audit log monitoring via the Audit Logs feature set, apply GRANT AUDIT READ TO <USER>.

Activation and setup

Follow these steps to configure your device for SAP HANA database monitoring.

Add DB instance

  1. Go to Dynatrace Hub Hub.

  2. Select and install SAP HANA extension. This enables the extension in your monitoring environment.

    • Required permission: Change monitoring settings

  3. Select Add DB Instance in the Databases Databases. This opens the Add DB Instance wizard.

  4. Select SAP HANA section in the wizard.

Select hosting type

Select a hosting type from the options. This choice determines which script generates the necessary database objects later in the process.

  1. From the Add DB Instance wizard, select the host type that matches your requirement.
  2. Select Next.

Select ActiveGate group

  1. Select the ActiveGate group to determine which ActiveGates will run the extension.
  2. Select Next step.

Create a connection

Set up the connection to your database instance.

  1. Name the connection, so you can identify it later.
  2. Add the details in the Configure connection section.
    1. Provide the following connection details:
      • Host
      • Port
      • Add and select JDBC driver if not already available.
  3. Provide the Authenticate credentials directly or use secure alternatives.
    • Basic credentials: With basic authentication, authentication details passed to Dynatrace when activating monitoring configuration are masked to prevent them from being retrieved.
    • Credential vault: Use vault credentials to securely store and retrieve database credentials.
  4. Select Next.

Install instance

  1. Add manual configurations based on the monitoring requirements.
  2. Select Create DB instance monitoring.

Details

This extension connects remotely via an ActiveGate to your SAP HANA Database using the provided credentials. It retrieves metrics via the database's Monitoring Views provided by the database itself.

Licensing and cost

The Table Information feature set was added in version 2.0.0.

This feature set is enabled by default for new monitoring configurations. Note that the metrics listed below can incur high licensing costs.

  • sap.hana.db.service.table.locks
  • sap.hana.db.service.table.records
  • sap.hana.db.service.table.size

DQL and Logs

The extension ingests the following individually as log messages:

  • 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.

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
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
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
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
Service Response Time
Metric nameMetric keyDescription
Service Response Timesap.hana.db.service.response_timeAverage Response Time of the Service (Host Process)
Disk Size Usage
Metric nameMetric keyDescription
Disk Usagesap.hana.db.host.disk_usageHost Disk Usage
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
Host Agent Network Rates
Metric nameMetric keyDescription
NIC Ratesap.hana.db.host.network_interface.rateNIC IO Speeds (both Tx and Rx)
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
Trace File Information
Metric nameMetric keyDescription
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
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
Active Prepared Statements
Metric nameMetric keyDescription
Active Statementssap.hana.db.current_active_prepared_statementsNumber of Current Active Prepared Statements
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
Audit Logs
Metric nameMetric keyDescription
Host Temp Heap Usage
Metric nameMetric keyDescription
Heap Temp Memory Usagesap.hana.db.host.heap_temp_memory_usageHeap - Temporary Memory Usage
Expensive Statement Metrics
Metric nameMetric keyDescription
Total Expensive Statementssap.hana.db.sql.total_expensive_statementsTotal Number of Expensive SQL Statements
Out Of Memory Events
Metric nameMetric keyDescription
SQL Plan Cache Size
Metric nameMetric keyDescription
SQL Plan Cache Sizesap.hana.db.current_sql_plan_cache_sizeCurrent Number of SQL Plans in Cache
Unloads Due to Low Memory
Metric nameMetric keyDescription
Low Memory Unloadssap.hana.db.service.low_memory_unloads.countNumber of Unloads due to Low Memory
Current Alerts
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
Expensive Statements
Metric nameMetric keyDescription
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
HANA License
Metric nameMetric keyDescription
Limitsap.hana.db.license.limitLicense Information including Licensed Size in GB

FAQ

What is the Custom Metric Usage of this extension?

The formula for consumption of the extension is:

Per database and 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 typically around 9, including processes such as 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