Monitoring SAP HANA

You can monitor the SAP HANA database with Instana by using the SAP HANA sensor. The SAP HANA sensor is automatically deployed and installed after you install the Instana agent. Instana supports both local and remote monitoring of the SAP HANA database.

Supported information

You can monitor the SAP HANA database only if the Instana agent uses the Azul Zulu 1.8 runtime. Eclipse OpenJ9 11 is not supported.

Configuring the SAP HANA sensor

With the SAP HANA sensor, you can monitor the SAP HANA database both locally and remotely. Local monitoring of SAP HANA involves setting up the Instana agent on the same host as your SAP HANA process, while remote monitoring involves setting up the agent on a separate host.

Local monitoring

In local monitoring, the sensor collects both host metrics and HANA database metrics, offering a comprehensive full-stack view of the data.

Depending on the mode in which SAP HANA is run (multiple container or single container), you can set different username and password combinations in the agent configuration yaml file <instana-agent-dir>/etc/instana/configuration.yaml to connect to the database.

The configuration parameters for local monitoring are shown in the following example:

# SAP HANA
com.instana.plugin.saphana:
 local:
   singleContainer:
     user: ''
     password: ''
   multiContainer:
     HXE:
       user: ''
       password: ''
     my-test-db:
       user: ''
       password: ''

The default user is SYSTEM.

Remote monitoring

In remote monitoring, the Instana SAP HANA sensor monitors SAP HANA databases that are deployed on different hosts than the one hosting the Instana agent. The SAP HANA sensor can monitor more than one database.

The configuration parameters for remote monitoring are shown in the following example:

# SAP HANA
com.instana.plugin.saphana:
  remote: # multiple remote configurations are supported
    - host: 'remote.host-1.com'
      port: '' #sql port
      databaseName: '' 
      user: '' 
      password: ''
    - host: 'remote.host-2.com'
      port: '' #sql port
      databaseName: '' 
      user: '' 
      password: ''

For the single container mode, the database name is blank. For the multi-container mode, you must enter a value for the database name.

Monitoring with the static agent

When you use the static agent, you need to provide the com.sap.cloud.db.jdbc:ngdbc driver manually.

To monitor the SAP HANA database with the static agent, complete the following steps:

  1. Download the ngdbc-2.4.64.jar driver from the Maven Central Repository.
  2. Add the ngdbc-2.4.64.jar driver to the <agent-installation-dir>/system/com/sap/cloud/db/jdbc/ngdbc/2.4.64 directory.
  3. Restart the agent.

Monitoring SAP HANA on PowerPC (Little Endian)

Azul Zulu 1.8 runtime is not available for the PowerPC Little Endian architecture.

To monitor SAP HANA on PowerPC, complete the following steps:

  1. Download Java 8.

  2. Go to the <agent-installation-dir>/bin directory, and open the setenv file.

  3. Add the line export JAVA_HOME=<path-to-java-home> after UNSET JAVA_HOME as shown in the following example:

    unset JAVA_HOME
export JAVA_HOME=<path-to-java-home>

  4. Save the changes and close the file.

  5. Restart the Instana agent to apply the changes.

For more information about agent installation prerequisites and supported JDKs, see Installing host agents.

Viewing metrics

To view metrics from SAP HANA in infrastructure view, complete the following steps:

  1. From the navigation menu, select Infrastructure.
  2. Click an SAP HANA host.
  3. Click Open Dashboard.

You can see the SAP HANA dashboard with all the tracked configuration and metrics.

Tracked configuration

  • System ID
  • Database Name
  • Instance Number
  • Version
  • Port
  • Usage
  • Maximum Number of Sessions
  • Host Status

Metrics

  • Total CPU Utilization
  • CPU Time
  • Memory Usage
  • Disk Usage
  • Sessions
  • Threads
  • Job Worker Threads
  • SQL Executor Threads
  • Workload
  • Requests
  • Alerts
  • Connections
  • Garbage Collection Statistics
  • Expensive Statements
  • SQL Plan Cache Statistics
  • Lock Wait Statistics
  • Service Details
  • Service Network I/O Statistics
  • Table Size
  • Aggregated Cache Information
  • Backup Progress
  • Scheduler Jobs
  • User Locks
  • System Events
  • Archive Log Backup

To see SQL Plan Cache Statistics metrics, set the plan_cache_statistics_enabled field to true in the agent configuration file.

The SAP HANA sensor generates built-in events for various scenarios. For more information, see Built-in Events Reference.