Monitoring SAP HANA

Depending on the type of monitoring required, the Instana agent can be installed on different OS for monitoring SAP HANA databases.

• Local monitoring (Instana agent is installed on the same host as the SAP HANA database):

  • Linux (x86 and IBM PowerPC 64-bit LE)

• Remote monitoring (Instana agent is installed on a different host and connects remotely to the SAP HANA database):

  • AIX
  • Linux (x86 and IBM PowerPC 64-bit LE)
  • Windows
  • IBM i (OS/400 PASE)
  • Apple macOS (64 bit - Intel and Apple silicon)

You can monitor the SAP HANA database only if the Instana agent uses Java 8 runtime.

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.22.12.jar driver from the Maven Central Repository.

2. Add the ngdbc-2.22.12.jar driver to the <agent-installation-dir>/system/com/sap/cloud/db/jdbc/ngdbc/2.22.12 directory.

3. To configure the agent to use the Java 8 runtime, complete the following steps:

   Note: You need to perform the following steps only for Instana release 282 and later or if the agent was set up earlier by using Eclipse OpenJ9 11.

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

   2. 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>
       

   3. Save the changes and close the file.

   4. Restart the Instana agent.

To configure the agent to use the Java 8 runtime, complete the following steps:

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

2. 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>
    

3. Save the changes and close the file.

4. Restart the Instana agent to apply the changes.

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

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 containers or single container), you can set different username and password combinations in the agent configuration yaml file *instanaAgentDir*/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:
     my-test-db1:
       user: ''
       password: ''
     my-test-db2:
       user: ''
       password: ''

 

The default user is SYSTEM.

# SAP HANA with instance number
com.instana.plugin.saphana:
 local:
   multiContainer:
     my-test-db1:
       user: ''
       password: ''
       instanceNumber: '00'

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

 

If you cannot use the SYSTEM user for local or remote monitoring, you can create a dedicated monitoring user with the required privileges.

CREATE USER instana_monitoring PASSWORD Instana123 NO FORCE_FIRST_PASSWORD_CHANGE;

GRANT CATALOG READ TO instana_monitoring;

GRANT SELECT ON SCHEMA _SYS_REPO TO instana_monitoring WITH GRANT OPTION;

GRANT SELECT ON _SYS_STATISTICS.STATISTICS_CURRENT_ALERTS TO instana_monitoring;

For local monitoring, add the following configuration:

com.instana.plugin.saphana:
  local:
   multiContainer:
     <DB Name>:
       user: ''
       password: ''
       trustStore: '<path to your truststore file location'
       trustStorePassword: '<Your truststore password>'
 

For remote monitoring, add the following configuration:

com.instana.plugin.saphana:
  remote:
    - host: 'remote.host-1.com'
      port: '' #sql port
      databaseName: ''
      user: ''
      password: ''
      trustStore: '<path to your truststore file location'
      trustStorePassword: '<Your truststore password>'
 

The SAP HANA sensor collects the following configuration data:

• Host
• Host Status
• Up Time
• System ID
• Database Name
• Instance Number
• Version
• Database Installed On
• Port
• Usage
• Service Status
• Maximum Number of Sessions

The following table outlines the frequency of metric collection by the SAP HANA sensor:

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