SAP HANA database monitoring

Learn how to monitor your SAP HANA database using the SAP HANA database ActiveGate extension.

Getting started

To get started, just click the chat button in the upper-right corner of the Dynatrace menu bar to contact a Dynatrace ONE Product Specialist. Dynatrace ONE will make sure you have what you need to monitor SAP HANA databases.

Prerequisites

  • Environment ActiveGate with remote access to the SAP HANA database server
  • A SAP HANA database user with the PUBLIC and MONITORING roles
  • SAP hdbcli Python library present on the ActiveGate host (see configuration instructions below)

Extension installation

To install the SAP HANA database extension

  1. Get the extension ZIP install file from your Dynatrace ONE Product Specialist via live chat. Don't rename the file.

  2. Unzip the ZIP file to the plugin_deployment directory of your ActiveGate host.

  3. Download the SAP hdbcli python wheel file for your ActiveGate's operating system.
    NOTE: Use the Python 3 Version (cp3x) that is at or below version 3.6

  4. Rename the file extension from .whl to .zip.

  5. Unzip the contents of the file into the plugin_deployment/custom.remote.python.sap_hana_db directory.
    The resulting file structure should look like this:

  6. In Dynatrace, go to Settings > Monitoring > Monitored technologies.

  7. Select Add new technology monitoring and then Add ActiveGate extension.

  8. Select Upload extension and upload the ZIP file.

  9. After you upload the extension, go to Settings > Monitoring > Monitored technologies and switch to the Custom extensions tab.

  10. Find the extension and select it to open it for Endpoint configuration.

  11. Enter the endpoint information.

    Setting Details

    Endpoint name

    Enter a meaningful endpoint name.

    Debug logging?

    Select this only if Dynatrace ONE requests it so they can investigate an issue.

    Name of custom device

    optional The default device name is <Host> - <Database Name>.

    Name of group

    optional Enter a custom group name for the new entity to be created. The default group name is SAP HANADB.

    Host

    The DNS or IP address that the database resides on.

    Port

    The default port is 3<Instance Number>15 or 3<Instance Number>40-42.

    Database user

    The user name of a SAP HANA database user with the PUBLIC and MONITORING roles.

    Database password

    The password of a SAP HANA database user with the PUBLIC and MONITORING roles.

    Choose ActiveGate

    Type or select an ActiveGate.

Metrics

Available metrics are listed below.

License

Name Comment Splittings
License Status TRUE, FALSE, EXPIRING_SOON (License Expires in less than 15 days) SYSTEM_ID

Infrastructure

Name Comment Splittings
Disk I/O Speed - Read MB/sec HOST, SERVICE_NAME, TYPE
Disk I/O Speed - Write MB/sec HOST, SERVICE_NAME, TYPE
Disk Usage Bytes HOST
Host CPU Utilization % HOST
Network Traffic Rates - Received KB/sec HOST, INTERFACE
Network Traffic Rates - Transmitted KB/sec HOST, INTERFACE
Open Connections Count of connections in RUNNING status -

Memory

Name Comment Splittings
Column Tables Memory Used Amount of used memory for the Column Store Tables HOST, SERVICE_NAME
Global Memory Allocation Limit Allocation limit for all processes HOST
Heap - Temporary Memory Used Sum of the Temporary Objects Sizes by Host HOST
Host Used Memory Size of the memory pool for all SAP HANA processes HOST
Host Used Physical Memory Used physical memory on the host HOST
Max Heap Memory Usage Max Memory Used in the categories Pool/ColumnStoreTables, Pool/PersistenceManager, Pool/RowEngine, Pool/Statistics HOST, CATEGORY
Row Store Allocated Size The amount of memory allocated for Row Store HOST, SERVICE_NAME
Unloads Due To Low Memory Number of Unloads due to reason "LOW MEMORY" -

Replication

Name Comment Splittings
Full Sync Status DISABLED, ENABLED, ACTIVE HOSTS, SERVICE_NAME
Oldest Replication Snapshot Seconds between now and the earliest snapshot for replication -
Replication Errors Number of replications with status ERROR -
Replication Log Shipping Delay Number of seconds between the last log position time and the shipped log position time HOSTS, SERVICE_NAME
Replication Mode SYNC, SYNCMEM, ASYNC, UNKNOWN HOSTS, SERVICE_NAME
Replication Status INITIALIZING, SYNCING, ACTIVE, ERROR, UNKNOWN HOSTS, SERVICE_NAME
Secondary Failover Count Number of times the primary has failed over to the secondary host HOSTS, SERVICE_NAME
Services Unknown Replication Count Number of services with replication status as UNKNOWN -

Backups

Name Comment Splittings
Backup Failures Number of backups in the FAILED state TYPE
Previous Backup Duration Number of seconds between the start and end of the most recent backup TYPE
Time Since Previous Backup Number of seconds since previous back up TYPE

Services

Name Comment Splittings
Service CPU Utilization % HOST, SERVICE_NAME
Service Memory Usage Bytes HOST, SERVICE_NAME
Service Status NO, YES, UNKNOWN, STARTING, STOPPING HOST, SERVICE_NAME
Service Response Time In milliseconds, the average of the last 1,000 requests to each service HOST, SERVICE_NAME

Savepoints

Name Comment Splittings
Savepoints The number of savepoints taken during that timeframe -
Savepoints Critical Phase Duration Amount of time spent in the critical phase portion of creating the savepoint SERVICE_NAME
Time Since Previous Savepoint Time since previous savepoint was taken. -

SQL statements

Name Comment Splittings
Expensive Statements exceeding Duration Limit Number of statements that took over the configured duration limit -
Expensive Statements exceeding Memory Limit Number of statements that took over the configured memory limit -
Min SQL Plan Cache Hit Ratio Minimum hit ratio of the SQL Plan Cache -

Transactions

Name Comment Splittings
Blocked Transactions Number of blocked transactions -
Current Transaction Locks Number of transactions with a lock where the status is not INACTIVE -
Max MergeDog Thread Duration The max execution time of the delta merge where the motivation is AUTO or CRITICAL -
Max Redo Size Max size of the redo log amount -
Max Undo Size Max size of the undo log amount -
Waiting Threads Number of threads that are not in the state INACTIVE or RUNNING -