Configuring the SAP HANA system for Foglight agent monitoring (4228989)

Database User Setup

To configure the monitoring of an SAP HANA system, the Foglight agent requires a database user with sufficient privileges on the SYSTEMDB and each tenant database for which monitoring is desired. 

Create an ordinary database user on each database in the SAP HANA system as follows: 

CREATE USER <username> PASSWORD <password> NO FORCE_FIRST_PASSWORD_CHANGE;
GRANT CATALOG READ TO <username>;
GRANT SELECT ON SCHEMA _SYS_STATISTICS TO <username>;

The username (and password) may be chosen independently on each database. 

Resource Tracking

Some features of the Foglight for SAP Hana depend on resource tracking within SAP HANA. These include SQL Query Plan memory monitoring and Expensive Statement tracking. The following steps are necessary to enable this functionality. 

CPU consumption estimation is on by default (for all SAP HANA versions greater than SAP HANA 1.0 SPS 11). Check that the global [resource_tracking] property ‘cpu_time_measurement_mode’ to still set to ‘on’.

The following SQL commands show how these settings can be changed globally:

ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('resource_tracking', 'enable_tracking') = 'on';

ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('resource_tracking', 'memory_tracking') = 'on';

ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('resource_tracking', 'cpu_time_measurement_mode') = 'on';

ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('expensive_statement', 'enable') = 'true';