Skip to technology filters Skip to main content
Dynatrace Hub

Extend the platform,
empower your team.

Popular searches:
Home hero bg
SAP HANA Database (remote monitoring)SAP HANA Database (remote monitoring)
SAP HANA Database (remote monitoring)

SAP HANA Database (remote monitoring)

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

Extension
Free trialDocumentation
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.

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

Dynatrace
Documentation
By Dynatrace
Dynatrace support center
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 nameMetric keyDescriptionUnit
HANA Database Limitssap.hana.db.limitsDatabase LimitsCount
HANA DB Build Versionsap.hana.db.build_versionSAP HANA DB Build VersionCount
IP Addressessap.hana.db.ip_addressesIP Address of HANA DB HostCount
Max Heap Usagesap.hana.db.host.max_heap_usageMax Heap Usage of the HostByte
Global Memory Allocation Limitsap.hana.db.host.global_memory_allocation_limitGlobal Memory Allocation LimitByte
Used Memorysap.hana.db.host.used_memoryHost Used MemoryByte
Used Physical Memorysap.hana.db.host.used_physical_memoryHost Used Physical MemoryByte
Volume Used Sizesap.hana.db.service.volume.usedUsed Size of VolumeByte
Total Volume Sizesap.hana.db.service.volume.totalTotal Size of VolumeByte
Service Memory Usedsap.hana.db.service.memory.usedMemory Usage of the Service (Host Process)Byte
Service Column Tables Memory Usedsap.hana.db.service.memory.column_tables_memory_usedColumn Tables Memory Usage by ServiceByte
Service Row Store Allocated Sizesap.hana.db.service.memory.row_store_allocated_sizeRow Store Allocated Size by ServiceByte
System CPU Usagesap.hana.db.service.system_cpu_usageRate of OS Kernel/System CPU used by index serverPercent
Service CPU Usagesap.hana.db.service.cpu_usageService CPU UsagePercent
Service Statussap.hana.db.service.statusCurrent Service StatusCount
Service Threadssap.hana.db.service.threadsNumber of Threads By TypeCount
Metric nameMetric keyDescriptionUnit
SQL Plan Cache Sizesap.hana.db.current_sql_plan_cache_sizeCurrent Number of SQL Plans in CacheCount
Metric nameMetric keyDescriptionUnit
Connection Usagesap.hana.db.connection_usageUsed Connection PercentagePercent
Transaction Usagesap.hana.db.transaction_usageUsed Transaction PercentagePercent
Active Transactionssap.hana.db.transactionsNumber of active transactionsCount
Open Connectionssap.hana.db.host.open_connectionsNumber of Current Connections without an end time, no matter the connection status (RUNNING/IDLE/QUEUING)Count
Running Connectionssap.hana.db.host.running_connectionsNumber of Current Connections in the RUNNING stateCount
Memory Usedsap.hana.db.host.memory_usedHost Memory UsedByte
Memory Sizesap.hana.db.host.memory_sizeHost Memory SizeByte
Memory Usagesap.hana.db.host.memory_usageHost Memory UsagePercent
CPU Usagesap.hana.db.host.cpuHost CPU UsagePercent
Disk Usedsap.hana.db.host.disk_usedHost Disk UsedByte
Disk Sizesap.hana.db.host.disk_sizeHost Disk SizeByte
Disk IO Read Speedsap.hana.db.host.disk_io_read_speedDisk IO Read SpeedMegaBytePerSecond
Disk IO Write Speedsap.hana.db.host.disk_io_write_speedDisk IO Write SpeedMegaBytePerSecond
Metric nameMetric keyDescriptionUnit
Network Insap.hana.db.host.network_inHost Network InByte
Network Outsap.hana.db.host.network_outHost Network OutByte
Metric nameMetric keyDescriptionUnit
Table Lockssap.hana.db.service.table.locksNumber of Locks On a TableCount
Record Countsap.hana.db.service.table.recordsNumber of Records in a TableCount
Table Sizesap.hana.db.service.table.sizeSize of a TableByte
Metric nameMetric keyDescriptionUnit
Backup Countsap.hana.db.backupsNumber of BackupsCount
Backup Sizesap.hana.db.backup.sizeEstimated backup sizeByte
Backup Time Since Previoussap.hana.db.backup.time_since_previousSeconds since Previous Backup Type was taken.Second
Backup Durationsap.hana.db.backup.durationHow long the different backup type took.Second
Failure Countsap.hana.db.backup.failures.countBackup Failure CountCount
Metric nameMetric keyDescriptionUnit
Total Expensive Statementssap.hana.db.sql.total_expensive_statementsTotal Number of Expensive SQL StatementsCount
Metric nameMetric keyDescriptionUnit
Tracefile Countsap.hana.db.tracefilesNumber of diagnostic filesCount
Service Max Merge Dog Thread Durationsap.hana.db.service.max_merge_dog_thread_durationMax Duration of the Merge Dog ThreadSecond
Blocked Transactionssap.hana.db.service.blocked_transactionsNumber of Blocked TransactionsCount
Current Transaction Lockssap.hana.db.service.current_transaction_locksNumber of current transaction locksCount
Minimum SQL Plan Cache Hit Ratiosap.hana.db.sql.min_sql_plan_cache_hit_ratioMinimum SQL Plan Cache Hit PercentagePercent
Metric nameMetric keyDescriptionUnit
Heap Temp Memory Usagesap.hana.db.host.heap_temp_memory_usageHeap - Temporary Memory UsageByte
Metric nameMetric keyDescriptionUnit
Low Memory Unloadssap.hana.db.service.low_memory_unloads.countNumber of Unloads due to Low MemoryCount
Metric nameMetric keyDescriptionUnit
Secondary Failover Countsap.hana.db.service.replication.secondary_failover_count.countReplication - Number of Secondary Failover CountCount
Log Shipping Delaysap.hana.db.service.replication.log_shipping_delayReplication - Number of seconds between Last Log Position and Shipped Log PositionSecond
Replication Errorssap.hana.db.service.replication.errorsReplication - Number of ErrorsCount
Replication Snapshot Agesap.hana.db.service.replication.snapshot_ageReplication - Age in Seconds of most recent SnapshotSecond
Metric nameMetric keyDescriptionUnit
Limitsap.hana.db.license.limitLicense Information including Licensed Size in GBGigaByte
Metric nameMetric keyDescriptionUnit
Disk Usagesap.hana.db.host.disk_usageHost Disk UsagePercent
Metric nameMetric keyDescriptionUnit
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 LimitPercent
Metric nameMetric keyDescriptionUnit
Service Response Timesap.hana.db.service.response_timeAverage Response Time of the Service (Host Process)MilliSecond
Metric nameMetric keyDescriptionUnit
Savepoints Countsap.hana.db.service.savepoints.countNumber of SavepointsCount
Savepoint Critical Phase Durationsap.hana.db.service.savepoint_critical_phase_durationDuration of Critical Phase in Savepoint creationSecond
Savepoint Time Since Previoussap.hana.db.service.savepoint_time_since_previousTime since Previous SavepointSecond
Metric nameMetric keyDescriptionUnit
Expensive Statements Exceeding Memory Limitsap.hana.db.sql.expensive_statements_exceeding_memory_limit.countNumber of Expensive SQL Statements that exceed the configured Memory LimitCount
Expensive Statements Exceeding Duration Limitsap.hana.db.sql.expensive_statements_duration_limit.countNumber of Expensive SQL Statements that exceed the configured Duration LimitCount
Expensive Statements Exceeding Memory Limitsap.hana.db.sql.expensive_statements_exceeding_memory_limitNumber of Expensive SQL Statements that exceed the configured Memory LimitCount
Expensive Statements Exceeding Duration Limitsap.hana.db.sql.expensive_statements_duration_limitNumber of Expensive SQL Statements that exceed the configured Duration LimitCount
Metric nameMetric keyDescriptionUnit
Active Statementssap.hana.db.current_active_prepared_statementsNumber of Current Active Prepared StatementsCount
Metric nameMetric keyDescriptionUnit
NIC Ratesap.hana.db.host.network_interface.rateNIC IO Speeds (both Tx and Rx)KiloBytePerSecond
Metric nameMetric keyDescriptionUnit
Disk Size By Schemasap.hana.db.schema.disk_used_sizeAbsolute disk usage per schemaByte
Disk Usage By Schemasap.hana.db.schema.total_disk_size_percentageRelative disk usage per schemaPercent

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
Dynatrace Hub
Get data into DynatraceBuild your own app
All (775)Log Management and AnalyticsKubernetesAI and LLM ObservabilityInfrastructure ObservabilitySoftware DeliveryApplication ObservabilityApplication SecurityDigital ExperienceBusiness Analytics
Filter
Type
Built and maintained by
Deployment model
SaaS
  • SaaS
  • Managed
Partner FinderBecome a partnerDynatrace Developer

Discover recent additions to Dynatrace

Problems logo

Problems

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

Logs logo

Logs

Explore all your logs without writing a single query.

Security Investigator logo

Security Investigator

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

Business Flow logo

Business Flow

Track, analyze, and optimize your critical business processes.

Cost & Carbon Optimization logo

Cost & Carbon Optimization

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

Davis Anomaly Detection logo

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 logo

Notebooks

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

Dashboards logo

Dashboards

Transform complex data into clear visualizations with custom dashboards.

Automate your processes

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

Workflows logo

Workflows

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

Jira logo

Jira

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

Slack logo

Slack

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

Secure your cloud application

See vulnerabilities and attacks in your environment.

Security Overview logo

Security Overview

Get a comprehensive overview of the security of your applications.

Code-Level Vulnerabilities logo

Code-Level Vulnerabilities

Detect vulnerabilities in your code in real time.

Threats & Exploits logo

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.
Learn More
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.
Learn more