Dynatrace Hub

Extend the platform,
empower your team.

SAP HANA Database (remote monitoring)

Easily understand the health and performance of your SAP HANA databases.

Extension by Dynatrace

Free trial Documentation

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!

Product information
Release notes

Overview

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

Get started

Prerequisities

A SAP HANA database user with the PUBLIC and MONITORING roles
SAP HANA DB JDBC Driver downloaded from here
- Copy ngdbc-2.14.7.jarto 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

Then activate the extension in your environment using the in-product Hub, provide the necessary device configuration and you’re all set up.

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.

Use cases

This is intended for users, who:

Would like to monitor the health state and performance of their SAP HANA Databases.

This enables you to:

Monitor infrastructure with a comprehensive dashboard
Detect traffic anomalies and alert on them
Take pre-emptive measures to avoid service degradations

Resources

Documentation

Support

Built and supported by Dynatrace

Dynatrace support center

Subscribe to new releases

copy to clipboard

Extension content

Content typeNumber of items included

screen logs cards

screen injections

screen layout

list screen layout

metric query

metric metadata

screen metric tables

screen actions

generic relationship

screen entities lists

dashboards

screen properties

screen chart groups

generic type

Feature sets

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.

Feature setsNumber of metrics included

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

No matching metrics...

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

No matching metrics...

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

No matching metrics...

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

No matching metrics...

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

Related to SAP HANA Database (remote monitoring)

Custom Database Queries

Make generic databases queries and send the data to Dynatrace as metrics.

SAP GUI and ABAP platform

Automatic problem detection and visibility into every user transaction, and insight into the performance of RFC without changing any code.

Full version history

To have more information on how to install the downloaded package, please follow the instructions on this page.

ReleaseDate

v2.0.0 - Requires Reconfiguration

DXS-385 :

Added sap.hana.db.service.volume.used, sap.hana.db.service.volume.total, and func:sap.hana.db.service.volume.usage Volume Metrics
Added sap.hana.db.service.table.locks, sap.hana.db.service.table.records, and sap.hana.db.service.table.size Table Metrics
- Added vars for schema_name_filter and table_name_filter, this requires recreating the monitoring configurations hence the major version update.

DXS-494 :

Added sap.hana.db.current_active_prepared_statements and sap.hana.db.current_sql_plan_cache_size Metrics

DXS-613 :

Added Feature Set : Host Infrastructure Network Rates for sap.hana.db.host.network_interface.rate Metric
- Disable this Feature Set if SYS.M_HOST_AGENT_METRICS table does not exist
Split out Service CPU and Service Repsonse Time Metrics into separate Feature Sets
- sap.hana.db.service.cpu_usage is kept as part of Default Feature Set
- sap.hana.db.service.response_time is now a part of the new "Service Response Time" Feature Set
  - Disable this Feature Set if RESPONSE_TIMEcolumn does not exist in tableSYS.M_SERVICE_STATISTICS
The sap.hana.db.license.limit now shows a -1 if there is no PRODUCT_LIMIT column in the M_LICENSE view

Additional New Metrics & Changes :

Changed Query for sap.hana.db.host.open_connections Metric
- For old query see new metric key : sap.hana.db.host.running_connections
New Logs Ingested :
- Out Of Memory Events
- Trace File Information (Name, Size, Modification Time)
New Metrics :
- 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 & Transactions
- sap.hana.db.service.system_cpu_usage - indexserver and nameserver only

v1.1.3

Fixes for validation errors when uploading/deploying.

Fix for EXT-5079: SAP Hana DB extension 2.0 restarts continuously due to missing data.

v1.1.1

Minor update to fix UA Screen Actions and Descriptions

v1.1.0

Added feature sets : Current Alerts & Expensive Statements
- These use Log Ingest to gather query level information from _SYS_STATISTICS.STATISTICS_CURRENT_ALERTS and SYS.M_EXPENSIVE_STATEMENTS respectively.
Minor update to overview dashboard for backwards compatibility

v1.0.3

Updates to included Overview Dashboard for backwards compatibility

1.0.2 - Initial Release

Monitoring of metrics via Database Queries to M_ Monitoring Views
New SAP HANA Entities & Relationships
- SAP HANA Database (sql:hana_db_database)
- SAP HANA DB Service (sql:hana_db_service)
- SAP HANA DB Host (sql:hana_db_host)
Included Dashboard - SAP HANA DB Overview

Dynatrace Hub

Build your own app

All (669)Log Management and Analytics Kubernetes Infrastructure Observability Automations Application Observability Application Security Digital Experience Business Analytics

Dynatrace Developer