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

0 Results filtered by:

Default empty state

We couldn't find any results

You can search all listings, or try a different spelling or keyword. Still nothing? Dynatrace makes it easy to create custom apps.

Find a partnerLearn to build apps