SAP HANA database monitoring

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

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)

OneAgent on HANA host

You can optionally install OneAgent on a HANA host to get additional infrastructure data related to disk space and networking, as well as host crash and availability monitoring. However, OneAgent installed on a HANA host may interfere with database updates if it has automatic process injection enabled (default). If you decide to have OneAgent installed on your HANA host, make sure you disable process auto-injection.

Disable auto-injection at installation time

To install OneAgent with the parameters to enable Infrastructure Monitoring mode and disable process injection, run the command below:

shellcopydownload
/bin/sh Dynatrace-OneAgent-Linux-<version>.sh --set-infra-only=true --set-auto-injection-enabled=false

Disable auto-injection after OneAgent installation

To disable auto-injection after OneAgent is installed

1. Open a terminal on your HANA host.
2. Run the oneagentctl command-line tool with the following parameters to enable Infrastructure Monitoring mode and disable process injection. The command will also restart the OneAgent service to automatically apply your changes.

shellcopydownload
./oneagentctl --set-infra-only=true --set-auto-injection-enabled=false --restart-service

For more information, see OneAgent configuration via command-line interface

Dynatrace web UI

1. In the Dynatrace menu, go to Hosts.
2. Find your HANA host and select it.
3. Select More (…) > Settings > Monitoring.
4. Turn off Full-stack monitoring and Auto-injection.

Extension installation

To install the SAP HANA database extension

1. In the Dynatrace menu, go to Hub.

2. Find and select SAP HANA Database.

3. Select Download to get the extension ZIP file. Don't rename the file.

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

5. Download the SAP hdbcli python wheel file for your ActiveGate's operating system.

   • For ActiveGate version 1.230 and earlier, use the closest Python 3 version (cp3x) that is at or below version 3.6.
   • For ActiveGate version 1.231+, use the closest version of the library (cp3x) that is at or below version 3.8.

   If there is no cp38 version of the .whl file for your OS, use the version that is closest to either cp36 or cp38, depending on your ActiveGate version.

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

7. Unzip the contents of the file into plugin_deployment/<EXTENSION-SPECIFIC-DIRECTORY>.
   The resulting file structure should look like this:

   File structure

   plaintextcopydownload
   plugin_deployment
      - <EXTENSION-SPECIFIC-DIRECTORY>
          - all files from unzipping extension ZIP file
          - hdbcli
              - __init__.py
              - dbapi.py
              - resultrow.py
          - hdbcli-<VERSION>.dist-info
          - pyhdbcli.abi3.so/pyhdbcli.pyd

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

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

10. Select Upload extension and upload the extension ZIP file.

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

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

13. Enter the endpoint information.

    Example configuration page

    

    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.
    Capture slow-running queries	SAP HANA Database extension version 1.004+ Some metrics require queries that can take longer than the extension timeout. This allows specific endpoints to not capture these metrics.1 Default is to capture these metrics.
    Choose ActiveGate	Type or select an ActiveGate.

    ¹

    Currently, the only metric that would not be captured is Heap - Temporary Memory Used. See the Additional Information in the SAP HANA Documentation for more information about the view this metric uses.

Metrics

Available metrics are listed below.

License

Infrastructure

Memory

Replication

Backups

Services

Savepoints

SQL statements

Transactions