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
Dynatrace
Documentation
By Dynatrace
Dynatrace support center
Subscribe to new releases
Copy to clipboard

Extension content

Content typeNumber of items included
screen injections
2
screen layout
6
screen logs cards
2
metric metadata
68
list screen layout
3
document dashboard
1
screen chart groups
38
metric query
1
screen dql table
13
screen metric tables
5
screen actions
6
screen entities lists
11
generic relationship
7
screen properties
6
dashboards
1
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
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
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
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
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
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
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
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
Disk Usagesap.hana.db.host.disk_usageHost Disk UsagePercent
Metric nameMetric keyDescriptionUnit
Low Memory Unloadssap.hana.db.service.low_memory_unloads.countNumber of Unloads due to Low MemoryCount
Metric nameMetric keyDescriptionUnit
Network Insap.hana.db.host.network_inHost Network InByte
Network Outsap.hana.db.host.network_outHost Network OutByte
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
Heap Temp Memory Usagesap.hana.db.host.heap_temp_memory_usageHeap - Temporary Memory UsageByte
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
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
Total Expensive Statementssap.hana.db.sql.total_expensive_statementsTotal Number of Expensive SQL StatementsCount
Metric nameMetric keyDescriptionUnit
Limitsap.hana.db.license.limitLicense Information including Licensed Size in GBGigaByte

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.6.3

  • Added Audit Logs Feature Set
    • Additional Permissions GRANT AUDIT READ TO <USER> is needed.
  • Limited length of database host IP addresses to match dimension value length limit

Full version history

2.6.1

  • INFOBS-4366
    • Add dt.ip_addresses attribute to sql:hana_db_database entity type

Full version history

2.6.0

  • DXS-3317
    • Platform Screen Updates
    • Add Platform Dashboard
    • Add dt.security_context attribute to entities

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

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

All

194 Results filtered by:

Palo Alto firewalls logo

Palo Alto firewalls

Palo Alto extension for problems detection

Extension
Confluent Cloud (Kafka) logo

Confluent Cloud (Kafka)

Remotely monitor your Confluent Cloud Kafka Clusters and other resources!

Extension
Kong - Prometheus logo

Kong - Prometheus

Monitor Prometheus metrics exposed by Kong and proxied upstream services

Extension
Nutanix Clusters logo

Nutanix Clusters

Monitor Nutanix clusters' performance, usage and availability, with Nutanix API.

Extension
Luna Network HSM Device logo

Luna Network HSM Device

Monitor your Luna Network Hardware Security Module (HSM) Devices through SNMP.

Extension
Consul Service Mesh (StatsD) logo

Consul Service Mesh (StatsD)

Extend visibility into your Consul Service Mesh instances to monitor health and improve performance.

Extension
Microsoft IIS logo

Microsoft IIS

Flexible and secure web server for hosting with Windows Server.

Extension
Kubernetes Monitoring Statistics logo

Kubernetes Monitoring Statistics

Troubleshoot your Dynatrace Kubernetes monitoring and Prometheus integration.

Extension
Snyk logo

Snyk

Ingest Snyk vulnerability findings, scans, and audit logs.

Extension
Citrix DaaS & Virtual Apps and Desktops logo

Citrix DaaS & Virtual Apps and Desktops

Gain insight into your Citrix DaaS & Virtual Apps and Desktops environments

Extension
Google Memorystore logo

Google Memorystore

Get insights into Google Memorystore service metrics collected from the Google Operations API to ensure health of your cloud infrastructure.

Extension
Databricks Workspace logo

Databricks Workspace

Remotely monitor your Databricks Workspaces!

Extension
Uptime logo

Uptime

Monitor the uptime of your hosts

Extension
UPS Device logo

UPS Device

Monitor your Uninterruptible Power Supplies (UPS) over SNMP

Extension
Google App Engine (integration) logo

Google App Engine (integration)

Insights into Google App Engine service metrics collected from Operations API

Extensioncoming soon
Traceroute logo

Traceroute

Run traceroute commands and collect step performance metrics

Extension
[Deprecated] Kubernetes PVCs logo

[Deprecated] Kubernetes PVCs

Monitor your Kubernetes persistent volume claims and alert on capacity limits.

Extension
Google Cloud Storage Transfer logo

Google Cloud Storage Transfer

Get insights into Google Cloud Storage Transfer metrics collected from the Google Operations API to ensure health of cloud infrastructure.

Extension
NVIDIA GPU logo

NVIDIA GPU

Monitor base parameters of the GPU, including load, memory and temperature

Extension
Oracle Database logo

Oracle Database

Observe, analyze and optimize the usage, health and performance of your database

Extension
Cisco ACI/APIC logo

Cisco ACI/APIC

Get insights into your Cisco Application Centric Infrastructure (ACI)

Extension
Dell iDRAC logo

Dell iDRAC

Connect to the Redfish API to get insights into your Dell iDRAC environment

Extension
Azure Managed Apache Cassandra logo

Azure Managed Apache Cassandra

Gain insights into your Azure Managed Cassandra Instance health and performance

Extension
PayShield HSM Device logo

PayShield HSM Device

Monitor PayShield Payment Hardware Security Module (HSM) Devices through SNMP.

Extension
NetApp OnTap (Remote) logo

NetApp OnTap (Remote)

Remote extension that collects NetApp OnTap metrics from the OnTap 9.6+ API.

Extension
Google Firestore in Datastore mode logo

Google Firestore in Datastore mode

Get insights into Google Firestore in Datastore mode metrics collected from the Google Operations API to ensure health of infrastructure.

Extension
Redis (2.0) logo

Redis (2.0)

Collect important additional data for your Redis instances.

Extension
PHP-FPM logo

PHP-FPM

Monitor the PHP-FPM status of your applications with this extension.

Extension
Timedrift Monitoring logo

Timedrift Monitoring

Monitor your host's NTP/Chrony Time Offset!

Extension
Apache Kafka logo

Apache Kafka

Automatic and intelligent observability with trace and metric insights.

Extension
MongoDB (local or remote monitoring) logo

MongoDB (local or remote monitoring)

Monitor your MongoDB servers either locally or remotely!

Extension
Connection Pools: C3P0 logo

Connection Pools: C3P0

Application server method of pooling and sharing connections to a database.

Extension
AWS Entities for Metric Streaming logo

AWS Entities for Metric Streaming

Analyse metrics in the context of an entity based on AWS Metric Streaming.

Extension
MongoDB Atlas logo

MongoDB Atlas

Remotely monitor your SaaS installation of MongoDB (Atlas)

Extension
Microsoft SQL Server logo

Microsoft SQL Server

Improve the health and performance monitoring of your Microsoft SQL Servers.

Extension
IBM MQ Appliance logo

IBM MQ Appliance

Monitor your IBM MQ Appliances over SNMP

Extension
Google Apigee logo

Google Apigee

Get insights into Google Apigee service metrics collected from the Google Operations API to ensure health of your cloud infrastructure.

Extension
Oracle Autonomous Database on OCI logo

Oracle Autonomous Database on OCI

Monitor health and performance of the Oracle Autonomous Database.

Extension
Google Pub/Sub Lite logo

Google Pub/Sub Lite

Get insights into Google Pub/Sub Lite service metrics collected from the Google Operations API to ensure health of the cloud infrastructure.

Extension
Infoblox DDI logo

Infoblox DDI

Monitor Infoblox DDI using SNMP

Extension
SAP HANA Database (remote monitoring) logo

SAP HANA Database (remote monitoring)

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

Extension
Connection Pools: WebSphere Liberty logo

Connection Pools: WebSphere Liberty

Application server method of pooling and sharing connections to a database.

Extension
Google Cloud Composer logo

Google Cloud Composer

Get insights into Google Cloud Composer metrics collected from the Google Operations API to ensure health of your cloud infrastructure.

Extension
Google Cloud Spanner logo

Google Cloud Spanner

Get insights into Google Cloud Spanner metrics collected from the Google Operations API to ensure health of your cloud infrastructure.

Extension
IBM i logo

IBM i

Collect performance data from your IBM i Hosts via this Remote extension.

Extension
Google reCAPTCHA Enterprise logo

Google reCAPTCHA Enterprise

Get insights into Google reCAPTCHA Enterprise metrics collected from the Google Operations API to ensure health of your cloud infrastructure

Extension
.NET logo

.NET

Automatic end-to-end observability for .NET applications and processes.

Extension
Google Cloud's operations suite logo

Google Cloud's operations suite

Get insights into Google Cloud's operations suite metrics collected from the Google Operations API to ensure health of cloud infrastructure.

Extension
Google Vertex AI logo

Google Vertex AI

Get insights into Google Vertex AI service metrics.

Extension
Oracle Exadata logo

Oracle Exadata

Monitor Oracle Exadata systems for performance, usage and availability

Extension