(DI-2305) Messages when monitoring HANA Expensive statements
In case you see any of the below-mentioned messages when monitoring HANA Expensive statements, the configuration properties in the global.ini file need to be set up. Otherwise, the following KPIs for HANA Expensive statements are not collected:
HDB_SQL_EXP_STMT_DUR_NUM - Number of expensive SQL statements exceeding the time limit
HDB_SQL_EXP_STMT_NUM - Number of expensive statements exceeding the memory limit
1) Expensive statement monitoring is not enabled in the HANA config file
Monitoring of expensive statements is not enabled in HANA global configuration file. The collector is not able to monitor expensive statements when this configuration property is not defined or disabled.
Setup procedure
Execute transaction DB02.
Navigate to 'Configuration->INI files'
Expand the 'INIFILE PARAMETER LIST' node
Navigate to the following path: global.ini->expensive_statement->enable.
Double-click the' enable' node
Set the value to 'true'.
2) Duration threshold for expensive statement is not set in HANA config file
Missing configuration property 'threshold_duration' in HANA global configuration file for expensive statements on the system. The collector is not able to calculate the KPI on memory-expensive statements when this configuration property is not defined.
Setup procedure
Execute transaction DB02
Navigate to 'Configuration->INI files'
Expand the 'INIFILE PARAMETER LIST' node
Navigate to the following path: global.ini->expensive_statement->threshold_duration
Double-click 'threshold_duration' node
Set a valid system value that is greater than zero.
03) Resource tracking is not set in the HANA config file
Property for tracking resources is switched off in HANA global configuration file or not defined. The collector is not able to monitor expensive statements when this configuration property is switched off or not defined.
Setup procedure
Execute transaction DB02
Navigate to 'Configuration->INI files'
Expand the 'INIFILE PARAMETER LIST' node
Navigate to the following path: global.ini->resource_tracking->enable_tracking
Double-click 'enable_tracking' node
Set the system value to 'on'.
04) Memory tracking is not set in the HANA config file
The property for tracking memory is switched off in HANA global configuration file or not defined. The collector is not able to monitor expensive statements when this configuration property is switched off or not defined.
Setup procedure
Execute transaction DB02
Navigate to 'Configuration->INI files'
Expand the 'INIFILE PARAMETER LIST' node
Navigate to the following path: global.ini->resource_tracking->memory_tracking
Double-click 'memory_tracking' node
Set the system value to 'on'.
05) Memory threshold for expensive statement is not set in HANA config file
This message is not raised anymore since 2211 release.
Missing configuration property 'threshold_memory' in HANA global configuration file for expensive statements on the system. The collector is not able to calculate the KPI on memory-expensive statements when this configuration property is not defined.
Setup procedure
Execute transaction DB02
Navigate to 'Configuration->INI files'
Expand the 'INIFILE PARAMETER LIST' node
Navigate to the following path: global.ini->expensive_statement->threshold_memory
Double-click 'threshold_memory' node
Set a valid system value that is greater than zero.