SAP HANA

Sensor (Data Collection)

Tracked Configuration

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

Metrics

  • CPU Usage
  • Memory Usage
  • Disk Usage
  • Connections
  • Threads
  • Job Worker Threads
  • SQL Executor Threads
  • Workload
  • Requests
  • Alerts

Configuration

Driver Installation

Due to licensing reasons, Instana can not provide automatic SAP HANA monitoring. Only SAP can distribute the driver jar for SAP HANA connection.

When the agent starts and discovers a SAP HANA Database where the driver has not been supplied, the agent will log this message:

2017-03-22T08:53:05.681+00:00 | ERROR | instana-scheduler-thread-1 | SapHana | 
com.instana.discovery-sap-hana - 1.1.0 | Cannot monitor Sap Hana without the driver ngdbc-2.0.jar
2017-03-22T08:53:05.681+00:00 | ERROR | instana-scheduler-thread-1 | SapHana | 
com.instana.discovery-sap-hana - 1.1.0 | For license reasons it cannot be provided 
by Instana and needs to be manullay obained and added to the agent

To add the driver to the agent, add it to this location: instana-agent/system/com/sap/db/jdbc/ngdbc/2.0/ngdbc-2.0.jar

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. Please note that the sensor requires a database to exist. That means a process called hdbindexserver was started by SAP HANA.

# SAP HANA
com.instana.plugin.saphana:
  singleContainer:
    user: '' #default is 'SYSTEM'
    password: ''
  multiContainer:
    DATABASE_NAME_1: #example 'HXE'
      user: '' #default is 'SYSTEM'
      password: ''
    DATABASE_NAME_2:
      user: '' #default is 'SYSTEM'
      password: ''