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

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 : 
	(40 + (2 * <# of Schemas>) +  (14 * <# of Services>) + (3 * <# of Schemas> * <Avg # of Tables per Schema>))

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
list screen layout
3
screen chart groups
38
metric metadata
61
metric query
1
screen metric tables
5
generic relationship
4
screen actions
6
screen entities lists
11
screen dql table
1
dashboards
1
screen properties
6
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
Tracefile Countsap.hana.db.tracefilesNumber of diagnostic filesCount
HANA Database Limitssap.hana.db.limitsDatabase LimitsCount
Limitsap.hana.db.license.limitLicense Information including Licensed Size in GBGigaByte
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 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
Service Threadssap.hana.db.service.threadsNumber of Threads By TypeCount
Minimum SQL Plan Cache Hit Ratiosap.hana.db.sql.min_sql_plan_cache_hit_ratioMinimum SQL Plan Cache Hit PercentagePercent
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
Heap Temp Memory Usagesap.hana.db.host.heap_temp_memory_usageHeap - Temporary Memory UsageByte
Metric nameMetric keyDescriptionUnit
Service Response Timesap.hana.db.service.response_timeAverage Response Time of the Service (Host Process)MilliSecond
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
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
Total Expensive Statementssap.hana.db.sql.total_expensive_statementsTotal Number of Expensive SQL StatementsCount
Metric nameMetric keyDescriptionUnit
SQL Plan Cache Sizesap.hana.db.current_sql_plan_cache_sizeCurrent Number of SQL Plans in CacheCount
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
Low Memory Unloadssap.hana.db.service.low_memory_unloads.countNumber of Unloads due to Low MemoryCount
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
Disk Size Usagesap.hana.db.disk_size_usageRatio of used disk space by DB tablesPercent
Connection Usagesap.hana.db.connection_usageUsed Connection PercentagePercent
Transaction Usagesap.hana.db.transaction_usageUsed Transaction PercentagePercent
Active Transactionssap.hana.db.transactionsNumber of active transactionsCount
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
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
CPU Usagesap.hana.db.host.cpuHost CPU UsagePercent
Disk Usedsap.hana.db.host.disk_usedHost Disk UsageByte
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
NIC Ratesap.hana.db.host.network_interface.rateNIC IO Speeds (both Tx and Rx)KiloBytePerSecond

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.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
Certified PartnersGet data into DynatraceBuild your own app
All (714)Log Management and AnalyticsKubernetesAI/ML ObservabilityInfrastructure ObservabilitySoftware DeliveryApplication ObservabilityApplication SecurityDigital ExperienceBusiness Analytics
Filter
Type
Built and maintained by
Deployment model
SaaS
  • SaaS
  • Managed
Dynatrace Developer
Filter
Type
Built and maintained by
Deployment model
SaaS
  • SaaS
  • Managed