(DI-2111) Error messages when monitoring HANA Expensive statements

Owned by SNP
Nov 05, 2021
2 min read

In case you see any of the below-mentioned error 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. Collector is not able to monitor expensive statements when this configuration property is not defined or disabled.

Setup procedure

  1. Execute transaction DB02.

  2. Navigate to 'Configuration->INI files'

  3. Expand 'INIFILE PARAMETER LIST' node

  4. Navigate to following path: global.ini->expensive_statement->enable.

  5. Double-click 'enable' node

  6. 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. Collector is not able to calculate the KPI on memory expensive statements when this configuration property is not defined.

Setup procedure

  1. Execute transaction DB02

  2. Navigate to 'Configuration->INI files'

  3. Expand 'INIFILE PARAMETER LIST' node

  4. Navigate to the following path: global.ini->expensive_statement->threshold_duration

  5. Double-click 'threshold_duration' node

  6. Set a valid system value that is greater than zero.

03) Memory threshold for expensive statement is not set in HANA config file

Missing configuration property 'threshold_memory' in HANA global configuration file for expensive statements on the system. Collector is not able to calculate the KPI on memory expensive statements when this configuration property is not defined.

Setup procedure

  1. Execute transaction DB02

  2. Navigate to 'Configuration->INI files'

  3. Expand 'INIFILE PARAMETER LIST' node

  4. Navigate to following path: global.ini->expensive_statement->threshold_memory

  5. Double-click 'threshold_memory' node

  6. Set a valid system value that is greater than zero.

04) 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. Collector is not able to monitor expensive statements when this configuration property is switched off or not defined.

Setup procedure

  1. Execute transaction DB02

  2. Navigate to 'Configuration->INI files'

  3. Expand 'INIFILE PARAMETER LIST' node

  4. Navigate to following path: global.ini->resource_tracking->enable_tracking

  5. Double-click 'enable_tracking' node

  6. Set the system value to 'on'.

05) Memory tracking is not set in the HANA config file

Property for tracking memory is switched off in HANA global configuration file or not defined. Collector is not able to monitor expensive statements when this configuration property is switched off or not defined.

Setup procedure

  1. Execute transaction DB02

  2. Navigate to 'Configuration->INI files'

  3. Expand 'INIFILE PARAMETER LIST' node

  4. Navigate to following path: global.ini->resource_tracking->memory_tracking

  5. Double-click 'memory_tracking' node

  6. Set the system value to 'on'.