Dynatrace Hub

Extend the platform,
empower your team.

Popular searches:

SAP HANA Database (remote monitoring)

SAP HANA Database (remote monitoring)

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

Extension by Dynatrace

Free trial Documentation

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.

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

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.

NOTE

Starting with v2.0.0 the feature set Table Information was added.

Due to the nature of the metrics listed below, please use the filters Schema Name Filter and Table Name Filter to limit the data being collected. Leaving these filters empty can lead to a high number of dimensions meaning high licensing costs. Syntax for the filters can be found here and here

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.

Resources

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

1

screen injections

1

screen layout

3

list screen layout

3

metric query

1

metric metadata

58

screen metric tables

4

screen actions

6

generic relationship

4

screen entities lists

11

dashboards

1

screen properties

3

screen chart groups

19

generic type

3

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

Discover recent additions to Dynatrace

Site Reliability Guardian

SRG: Automated change impact analysis for your deployment and release processes

DevSecOps Lifecycle Coverage with Snyk

Connect Snyk container scans and Dynatrace runtime insights for strong security.

Business Flow

Know your business result and see problematic process steps.

Salesforce Insights

Provides salesforce usage insights

Carbon Impact

Provides the information about site's carbon footprint

Analyze your data

Understand your data better with deep insights and clear visualizations.

Notebooks

Create powerful, data-driven documents for custom analytics and collaboration.

Dashboards

Transform complex data into clear visualizations with custom dashboards.

Automate your processes

Turn data and answers into actions, securely, and at scale.

Workflows

Automate tasks in your IT landscape, remediate problems, and visualize processes

Jira for Workflows

Jira Integration for managing Jira issues via Workflow actions

Slack for Workflows

Automate Slack messaging for security incidents, attacks, remediation, and more.

Secure your cloud application

See vulnerabilities and attacks in your environment.

Security overview

Get a comprehensive overview of the security of your applications.

Third-party vulnerabilities

Detect vulnerabilities in real time, with context and automated risk assessment.

Code-level vulnerabilities

Detect vulnerabilities in your code in real time.

Attacks

Get a real-time overview of all the attacks on your environment.

Are you looking for something different?We have hundred of apps, extensions, and other technologies to customize your environment

Leverage our newest innovations of Dynatrace Saas

Kick-start your app creation

Kick-start your app creation

Whether you’re a beginner or a pro, Dynatrace Developer has the tools and support you need to create incredible apps with minimal effort.

Go to Dynatrace Developer

Upgrading from Dynatrace Managed to SaaS

Upgrading from Dynatrace Managed to SaaS

Drive innovation, speed, and agility in your organization by seamlessly and securely upgrading.

Log Management and Analytics

Log Management and Analytics

Innovate faster and more efficiently with unified log management and log analytics for actionable insights and automation.