Configuring SAP HANA direct connection setup

Environment name

Host

Connection method

Instance number or port

Enter the SAP HANA database instance number or SQL port to monitor.

Query name

SQL query

Enter the SQL query. Do not end the query with a semi-colon (;).

Collection time (min)

Specify the collection time interval in minutes. Default value is 10 minutes.

Enable number of records annotation

Select this check box to display the query result as an annotation on the number of records metric.

Files

Select the check box to monitor performance and availability of files usage.

For more details, see the Files-SHM_FILES monitoring category.

Services

Select the check box to monitor performance and availability of services.

For more details, see the Services-SHM_SERVICES monitoring category.

Health

Select the check box to monitor performance and availability of health indicators like CPU utilization and disk usage.

For more details, see the Health-SHM_HEALTH monitoring category.

Minimum alerts severity for monitoring

Select the severity level at which you want the KM to generate alerts.

Logging 

Select the check box to enable debugging operations for all SAP HANA instances configured on this environment.

The log files are created in the following PATROL_HOME directories:

• Java: PATROL_HOME/Patrol3/shmkm/logs/java
• PSL: PATROL_HOME/Patrol3/log/shm-*.kmlog

By default, device mapping is enabled and all the SAP HANA database instances are discovered under the SAP HANA host device.

If the check box is clear, all the SAP HANA database instances are discovered under the PATROL Agent host device.

Java path

Enter the path to the JRE directory on the PATROL Agent host. The Java version must be 8 or later. 
For example:

• Windows: C:\Program Files (x86)\Java\jre8
• Unix\LINUX: /usr/java8_64/

Alternatively, you can also use the $JAVA_HOME environment variable in this field. If you use the $JAVA_HOME variable, the Java location depends on the following:

• If the user name and password are not entered for the Java collector settings; the KM uses the Java location of the user that is running the PATROL Agent
• A user name and password are entered for the Java collector settings; the KM uses Java location of the user entered in the collector settings.
• If this field is left blank, the KM looks for the Java executable in the Patrol3\openjdk\ and Patrol3\jre64 location
  If you enter a path for the JRE directory, you must enter the full path. Do not use the short path format.

JVM arguments

Enter the Java Virtual Machine (JVM) arguments for the Java collector.

User name

Enter the local user name to start the Java process.

Password

Confirm password

Enter the user password to start the Java process.

Availability collection interval (min)

Enter the time interval to check for the environment's availability for collecting data.

The default interval is one minute.

Data collection interval (min)

Enter the time interval for data collection from the environment.

The default interval is five minutes.

Note: Entering a data collection time that is less than 5 minutes results in a performance issue for the KM.

Long running data collection queries (min)

Enter the time interval to determine when a running query is blocked. The query is blocked because its execution duration is equal to or greater than this interval's threshold.

The default interval is 30 minutes.