SAP HANA Database (remote monitoring)

Supported by Dynatrace

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

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.

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

Detail

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.

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.

Metrics

Name	Metric key	Unit	Description
Open Connections	sap.hana.db.host.open_connections	Count	Number of Current Connections to that Database
CPU Usage	sap.hana.db.host.cpu	Percent	Host CPU Usage
Disk Used	sap.hana.db.host.disk_used	Byte	Host Disk Usage
Disk IO Read Speed	sap.hana.db.host.disk_io_read_speed	MegaBytePerSecond	Disk IO Read Speed
Disk IO Write Speed	sap.hana.db.host.disk_io_write_speed	MegaBytePerSecond	Disk IO Write Speed
NIC Rate	sap.hana.db.host.network_interface.rate	KiloBytePerSecond	NIC IO Speeds (both Tx and Rx)

Name	Metric key	Unit	Description
Secondary Failover Count	sap.hana.db.service.replication.secondary_failover_count.count	Count	Replication - Number of Secondary Failover Count
Log Shipping Delay	sap.hana.db.service.replication.log_shipping_delay	Second	Replication - Number of seconds between Last Log Position and Shipped Log Position
Replication Errors	sap.hana.db.service.replication.errors	Count	Replication - Number of Errors
Replication Snapshot Age	sap.hana.db.service.replication.snapshot_age	Second	Replication - Age in Seconds of most recent Snapshot

No matching metrics...

Name	Metric key	Unit	Description
Expensive Statements Exceeding Memory Limit	sap.hana.db.sql.expensive_statements_exceeding_memory_limit.count	Count	Number of Expensive SQL Statements that exceed the configured Memory Limit
Expensive Statements Exceeding Duration Limit	sap.hana.db.sql.expensive_statements_duration_limit.count	Count	Number of Expensive SQL Statements that exceed the configured Duration Limit

Name	Metric key	Unit	Description
Low Memory Unloads	sap.hana.db.service.low_memory_unloads.count	Count	Number of Unloads due to Low Memory

No matching metrics...

Name	Metric key	Unit	Description
Savepoints Count	sap.hana.db.service.savepoints.count	Count	Number of Savepoints
Savepoint Critical Phase Duration	sap.hana.db.service.savepoint_critical_phase_duration	Second	Duration of Critical Phase in Savepoint creation
Savepoint Time Since Previous	sap.hana.db.service.savepoint_time_since_previous	Second	Time since Previous Savepoint

Name	Metric key	Unit	Description
Backup Time Since Previous	sap.hana.db.backup.time_since_previous	Second	Seconds since Previous Backup Type was taken.
Backup Duration	sap.hana.db.backup.duration	Second	How long the different backup type took.
Failure Count	sap.hana.db.backup.failures.count	Count	Backup Failure Count

Versions

Keep up-to-date with newest releases

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

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

Download

v1.1.1

Minor update to fix UA Screen Actions and Descriptions

Download

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

Download

v1.0.3

Updates to included Overview Dashboard for backwards compatibility

Download

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