SAP HANA Multi-Tenant connection setup

After you have installed the PATROL for SAP HANA, you must configure a monitoring policy.

You can use the information in this topic to configure SAP HANA Multi- Tenant connection setup monitoring policy with the TrueSight console.

This topic includes the following information:

Before you begin

You must have downloaded and install the SAP HANA KM.

To configure the monitor type

In the Add Monitoring Configuration panel, select the following parameters for the SAP HANA KM:

Parameter	Selection
Monitoring Solution	SAP HANA
Monitor Profile	SAP HANA
Monitor Type	SAP HANA Multi-Tenant connection setup

For the Global Monitoring Setting, you can enable Logging for all of the configured PATROL Agent environments to confirm that all of the PATROL for SAP HANA environments are correctly configured.

To add an environment configuration

Click Add and enter the Environment Configuration details.

Field	Description
Environment name	Enter a unique environment name for monitoring the SAP HANA database. A container will be created with this environment name that will hold all the TrueSight instances. Warning Note The name cannot include blank spaces or any of the following special characters: # $ \ ' \| ~ ! @ % ^ ; ` ( ) { } ? \ " [ ] + = & : > < * / Do not use non-English characters to specify an environment name. Once you save the environment configuration, you cannot change the name without losing the environment's historical data. You can change the environment name by making a copy of the monitoring solution and then you can change the environment name.

Field

Description

Environment name

Enter a unique environment name for monitoring the SAP HANA database. A container will be created with this environment name that will hold all the TrueSight instances.

Note

The name cannot include blank spaces or any of the following special characters: # $ \ ' | ~ ! @ % ^ ; ` ( ) { } ? \ " [ ] + = & : > < * /
Do not use non-English characters to specify an environment name.
Once you save the environment configuration, you cannot change the name without losing the environment's historical data. You can change the environment name by making a copy of the monitoring solution and then you can change the environment name.

The remaining environment details are in the following sections:

Custom SQL Queries details
Monitoring Categories details
Environment Settings details

SAP HANA connection details

Field	Description
Host	Enter the host name or IP address of the monitored SAP HANA database. The entry must not contain any character from the following: *'#\|~@%^;`(){}?\\"[]+=\&></**
Connection method	Specify the connection method: Instance number Instance port
Instance number or port	Based on the selection in the above field, enter the SAP HANA database instance number or port to monitor. Use comma separator to add multiple instances. Input must match the Regex pattern.
JDBC driver path	Enter the path of the JDBC driver file.
Credentials
User name	The monitoring user name of the SAP HANA Database.
Password Confirm password	The user password of the SAP HANA Database.

Custom SQL Queries details

Click Add and enter the custom SQL query details

Custom SQL Query
Query name	Enter a SQL query name. Warning Note The name cannot include blank spaces or any of the following special characters: # $ \ ' \| ~ ! @ % ^ ; ` ( ) { } ? \ " [ ] + = & : > < * / After you save the environment configuration, you cannot change the name without losing the environment's historical data. You can change the environment name by making a copy of the monitoring solution and then changing the environment name.
Connection number	Specify the SAP HANA database instance number to monitor.
SQL query	Enter the SQL query. Do not terminate the query with the semi-colon (;).
Collection time (minutes)	Specify the collection time interval in minutes. By default, the collection time interval is 10 minutes.
Enable number of records annotation	Select this option to display the query result as an annotation on the number of records metric.

Monitoring Categories details

Select the SAP HANA Database activity categories that you want to monitor.

Monitoring Categories	Description
Files	Monitors the files activity of the SAP HANA database. For more details, see the Files-SHM_FILES monitoring category.
Services	Monitors the services activity of the SAP HANA database For more details, see the Services-SHM_SERVICES monitoring category.
Health	Monitors the health activity of the SAP HANA database. For more details, see the Health-SHM_HEALTH monitoring category.
Alerts	Select this option to monitor the alerts activity of the SAP HANA database.

Environment Settings details

Field	Description
Logging	Select this option to enable debugging operations for all SAP HANA instances configured on this environment. The log files are created under PATROL_HOME directory: Java: PATROL_HOME/Patrol3/shmkm/logs/java PSL: PATROL_HOME/Patrol3/log/shm-*.kmlog
Device mapping	By default, device mapping on the TrueSight console is enabled. If enabled, all the SAP HANA Database instances are discovered under the SAP HANA host device. If it is disabled, all the SAP HANA Database instances are discovered under the PATROL Agent host device.
Java collector settings
Java home	Specify the path to the JRE directory (aka $JAVA_HOME environment variable) on the PATROL Agent host. The Java version must be version 8 or later. If you use the $JAVA_HOME variable, the Java location is depends on the following: No user name and password are entered for the Java collector settings; the KM uses the Java location of the user 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 you enter a path for the JRE directory, you must enter the full path, such as C:\Program files\Java\jre1.8.0_151. Do not use the short path format.
JVM Arguments	Enter the optional 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.
Collection settings
Availability Collection Interval (min)	The time interval used to check for the environment's availability for collecting data. The default interval is one minute.
Data Collection Interval (min)	The time interval used for data collection from the environment. The default interval is five minutes. Note: Entering a data collection time that is less than 5 minutes will result in a performance issue for the KM.
Long running data collection queries (min)	The time interval use 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.

After you have completed configuring the environment, click OK to add this to the environment configurations list. This environment is displayed on the Environment Configuration list.

Click Cancel to exit without saving any changes.

If you want to verify the configuration on your TrueSight console, click here.