SAP HANA Database (remote monitoring)

SAP HANA Database (remote monitoring)

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

Extension

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
- NOTE: These are the default directories and may be different depending how the ActiveGate installation was done and if it was customized.

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.

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.

FAQ

Q: What is the Custom Metric Usage of this extension?

A: The formula for consumption of the extension is:

Per Database & Host:

Logs : 
	Out Of Memory Events -> Each event is ingested as a log message
	Trace File Information -> Each tracefile is ingested as a log message 
	Current Alerts -> Each Current Alert is ingested as a log message 
	Expensive Statements - Each Expensive Statement is ingested as a log message

Metrics : 
56 + 
+ (2 * <# of Schemas>)      -> Schema Disk Metrics Feature Set
+ (3 * <# of Schemas> * <Avg # of Tables per Schema>)      -> Table Information Feature Set
+ (6 * <# of Services>)

NOTE: The # of Services is usually around 9. This includes processes like the compileserver, indexserver, nameserver, webdispatcher, and xs* processes

Subscribe to new releases

Copy to clipboard

Extension content

Content typeNumber of items included

screen layout

6

screen injections

1

screen logs cards

2

metric metadata

68

list screen layout

3

screen chart groups

38

metric query

1

screen metric tables

5

screen actions

6

screen entities lists

11

screen dql table

1

dashboards

1

screen properties

6

generic relationship

5

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 feature sets can be activated and deactivated by your administrator during configuration.

Feature setsNumber of metrics included

Metric name	Metric key	Description	Unit
HANA Database Limits	sap.hana.db.limits	Database Limits	Count
HANA DB Build Version	sap.hana.db.build_version	SAP HANA DB Build Version	Count
IP Addresses	sap.hana.db.ip_addresses	IP Address of HANA DB Host	Count
Max Heap Usage	sap.hana.db.host.max_heap_usage	Max Heap Usage of the Host	Byte
Global Memory Allocation Limit	sap.hana.db.host.global_memory_allocation_limit	Global Memory Allocation Limit	Byte
Used Memory	sap.hana.db.host.used_memory	Host Used Memory	Byte
Used Physical Memory	sap.hana.db.host.used_physical_memory	Host Used Physical Memory	Byte
Volume Used Size	sap.hana.db.service.volume.used	Used Size of Volume	Byte
Total Volume Size	sap.hana.db.service.volume.total	Total Size of Volume	Byte
Service Memory Used	sap.hana.db.service.memory.used	Memory Usage of the Service (Host Process)	Byte
Service Column Tables Memory Used	sap.hana.db.service.memory.column_tables_memory_used	Column Tables Memory Usage by Service	Byte
Service Row Store Allocated Size	sap.hana.db.service.memory.row_store_allocated_size	Row Store Allocated Size by Service	Byte
System CPU Usage	sap.hana.db.service.system_cpu_usage	Rate of OS Kernel/System CPU used by index server	Percent
Service CPU Usage	sap.hana.db.service.cpu_usage	Service CPU Usage	Percent
Service Status	sap.hana.db.service.status	Current Service Status	Count
Service Threads	sap.hana.db.service.threads	Number of Threads By Type	Count

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

Metric name	Metric key	Description	Unit
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
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
Memory Used	sap.hana.db.host.memory_used	Host Memory Used	Byte
Memory Size	sap.hana.db.host.memory_size	Host Memory Size	Byte
Memory Usage	sap.hana.db.host.memory_usage	Host Memory Usage	Percent
CPU Usage	sap.hana.db.host.cpu	Host CPU Usage	Percent
Disk Used	sap.hana.db.host.disk_used	Host Disk Used	Byte
Disk Size	sap.hana.db.host.disk_size	Host Disk Size	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
Network In	sap.hana.db.host.network_in	Host Network In	Byte
Network Out	sap.hana.db.host.network_out	Host Network Out	Byte

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

Metric name	Metric key	Description	Unit
Backup Count	sap.hana.db.backups	Number of Backups	Count
Backup Size	sap.hana.db.backup.size	Estimated backup size	Byte
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
Total Expensive Statements	sap.hana.db.sql.total_expensive_statements	Total Number of Expensive SQL Statements	Count

Metric name	Metric key	Description	Unit
Tracefile Count	sap.hana.db.tracefiles	Number of diagnostic files	Count
Service Max Merge Dog Thread Duration	sap.hana.db.service.max_merge_dog_thread_duration	Max Duration of the Merge Dog Thread	Second
Blocked Transactions	sap.hana.db.service.blocked_transactions	Number of Blocked Transactions	Count
Current Transaction Locks	sap.hana.db.service.current_transaction_locks	Number of current transaction locks	Count
Minimum SQL Plan Cache Hit Ratio	sap.hana.db.sql.min_sql_plan_cache_hit_ratio	Minimum SQL Plan Cache Hit Percentage	Percent

Metric name	Metric key	Description	Unit
Heap Temp Memory Usage	sap.hana.db.host.heap_temp_memory_usage	Heap - Temporary Memory Usage	Byte

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

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
Limit	sap.hana.db.license.limit	License Information including Licensed Size in GB	GigaByte

Metric name	Metric key	Description	Unit
Disk Usage	sap.hana.db.host.disk_usage	Host Disk Usage	Percent

Metric name	Metric key	Description	Unit
Table Size vs Allocated Limit Ratio	sap.hana.db.total_table_size_vs_allocation_limit_ratio	Ratio of used disk space by DB tables vs the Allocated Limit	Percent

Metric name	Metric key	Description	Unit
Service Response Time	sap.hana.db.service.response_time	Average Response Time of the Service (Host Process)	MilliSecond

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
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
Expensive Statements Exceeding Memory Limit	sap.hana.db.sql.expensive_statements_exceeding_memory_limit	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	Number of Expensive SQL Statements that exceed the configured Duration Limit	Count

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
NIC Rate	sap.hana.db.host.network_interface.rate	NIC IO Speeds (both Tx and Rx)	KiloBytePerSecond

Metric name	Metric key	Description	Unit
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

Full version history

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

ReleaseDate

Full version history

v2.5.0

DXS-2156
- Added variables to allow for custom interval for both regular and heavy queries
  - Please check heavy query interval as this may affect collection of some of the heavy query metrics.
- Added feature set metadata including recommended feature sets.

Full version history

v2.4.2

DXS-2207
- Added SAME_AS relationship between sql:hana_db_service entity type and process_group_instance
DXS-2247

New Feature Set Table Size vs Allocation Limit Usage
- sap.hana.db.disk_size_usage renamed to sap.hana.db.total_table_size_vs_allocation_limit_ratio
New Feature Set Host Agent Network Rates
- contains existing metric : sap.hana.db.host.network_interface.rate
Existing Feature Set Host Infrastructure Metrics
- New Metrics :
  - sap.hana.db.host.memory_used
  - sap.hana.db.host.memory_size
  - sap.hana.db.host.memory_usage
  - sap.hana.db.host.disk_size
Existing Feature Set Host Infrastructure Network Rates
- New Metrics :
  - sap.hana.db.host.network_in
  - sap.hana.db.host.network_out
Existing Feature Set Disk Size Usage
- New Metric :
  - sap.hana.db.host.disk_usage
New Feature Set HANA License
- Moved Metrics :
  - sap.hana.db.license.limit
New Feature Set Disk Size Usage :
- sap.hana.db.disk_size_usage
New Feature Set Schema Disk Metrics :
- Moved Metrics :
  - sap.hana.db.schema.disk_used_size
  - sap.hana.db.schema.total_disk_size_percentage
New Feature Set Base Metrics :
- Moved Metrics :
  - sap.hana.db.tracefiles
  - sap.hana.db.service.max_merge_dog_thread_duration
  - sap.hana.db.service.blocked_transactions
  - sap.hana.db.service.current_transaction_locks
  - sap.hana.db.sql.min_sql_plan_cache_hit_ratio
Updated Interval to 5 minutes for Property Type Metrics :
- sap.hana.db.limits
- sap.hana.db.license.limit
- sap.hana.db.ip_addresses
- sap.hana.db.build_version

Full version history

v2.2.0

DXS-791 - Customize Host Name
- Added new per-endpoint variable for custom host naming
  - This adds the custom_host dimension to all metrics
  - NOTE: This will create NEW entities if you edit/add this to existing configurations

Full version history

v2.1.9

Added database as attribute to Out Of Memory Events Log Messages
Added existing timeout variable to additional subgroups to help long running queries
DXS-1270 - ( delta/count based Expensive Statement metrics may stop working as expected if the SYS.M_EXPENSIVE_STATEMENTS hits the table records limit)
- Added new sap.hana.db.sql.total_expensive_statements Metric in "Expensive Statement Metrics" Feature Set
- Added new Extended Expensive Statement Metrics Feature Set
- Moved previous Expensive Statement Metrics to this new Feature Set:
  - sap.hana.db.sql.expensive_statements_exceeding_memory_limit.count
  - sap.hana.db.sql.expensive_statements_duration_limit.count
- Added new time stamp based metrics:
  - sap.hana.db.sql.expensive_statements_exceeding_memory_limit
  - sap.hana.db.sql.expensive_statements_duration_limit

Full version history

v2.1.3

DXS-679
- Add UA Screens for Dynatrace Platform
DXS-821
- Modify licensequery to correct single-row query returns more than one row exception
Change Queries used to ingest logs ( the Out Of Memory Events, Trace File Information, & Expensive Statements Feature Sets) from using CURRENT_UTCTIMESTAMP function to CURRENT_TIMESTAMP.

Full version history

v2.1.1
- Updated extension yaml to follow the v275 schema
- Add configurable timeout to these metric queries :
  - Backup Metrics - specifically the sap.hana.db.backup.size metric
  - Host Temp Heap Usage - specifically the sap.hana.db.host.heap_temp_memory_usage metric

Full version history

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

Full version history

v1.1.3

Fixes for validation errors when uploading/deploying.

Full version history

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

Full version history

v1.1.1

Minor update to fix UA Screen Actions and Descriptions

Full version history

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

Full version history

v1.0.3

Updates to included Overview Dashboard for backwards compatibility

Full version history

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

Problems

Analyze abnormal system behavior and performance problems detected by Davis AI.

Logs

Explore all your logs without writing a single query.

Security Investigator

Fast and precise forensics for security and logs on Grail data with DQL queries.

Business Flow

Track, analyze, and optimize your critical business processes.

Cost & Carbon Optimization

Track, analyze, and optimize your IT carbon footprint and public cloud costs.

Davis Anomaly Detection

Detect anomalies in timeseries using the Davis AI

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

Create, query, comment, transition, and resolve Jira tickets within workflows.

Slack

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.

Code-Level Vulnerabilities

Detect vulnerabilities in your code in real time.

Threats & Exploits

Understand, triage, and investigate application security findings and alerts.

Are you looking for something different?

We have hundreds 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.