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 PASSWORD NO FORCE_FIRST_PASSWORD_CHANGE;
GRANT CATALOG READ TO ;
GRANT SELECT ON SCHEMA _SYS_STATISTICS TO ;
The username (and password) may be chosen independently on each database.
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’.
© 2022 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz