Monitoring SAP HANA

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.

Currently, monitoring SAP HANA is available only if the agent uses Azul Zulu 1.8 runtime. Eclipse OpenJ9 11 is not supported.

Configuring the SAP HANA sensor

Database Connection

Depending on the mode in which SAP HANA is run (multi container vs single container), different username and password combinations can be set.

The sensor requires a database to exist. That means SAP HANA started a process called 'hdbindexserver'.

Local monitoring

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

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: ''

The database name is blank for the single container mode but for the multi-container mode, you must enter a value. To see SQL Plan Cache Statistics metrics, set the plan_cache_statistics_enabled field to true in the agent configuration file.

Providing drivers

When you use the offline agent, the com.sap.cloud.db.jdbc:ngdbc driver needs to be provided manually. The driver can be downloaded from the Maven Central Repository. Currently, the supported version is 2.4.64.

To add the drivers to the agent, add it to the directory <agent-installation-dir>/system/com/sap/cloud/db/jdbc/ngdbc/2.4.64.

Monitoring SAP HANA on PowerPC (Little Endian)

Azul Zulu 1.8 runtime is not available for PowerPC Little Endian architecture. Therefore, you must download Java 8 and set it in the setenv file within the <agent-installation-dir>/bin directory. After you download Java 8, specify the Java home path by adding the line, export JAVA_HOME=<path-to-java-home> after UNSET JAVA_HOME as shown in the following example: Restart the agent to apply the changes.

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

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

Sensor (Data Collection)

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