-
Title
Configuring the SAP HANA system for Foglight agent monitoring -
Description
What database setup and resource tracking requirements must be made to configure a SAP HANA system for Foglight agent monitoring? -
Resolution
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 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.
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.
Set the global [resource_tracking] properties ‘enable_tracking’ and ‘memory_tracking’ to ‘on.’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’.
To enable expensive statement tracking, set the global [expensive_statement] property ‘enable’ to ‘true.’ Optionally modify the following parameters from their defaults:- ‘threshold_duration’ in microseconds,
- 'threshold_memory' in bytes (only effective if resource and memory tracking are also enabled),
- 'threshold_cpu_time' in microseconds (only effective if resource and CPU time tracking are also enabled).
-
Additional Information
Current as of the 5.9.5.10.15 cartridge