(DI-2305) HANA Configuration file setup

Owned by SNP
May 03, 2023
1 min read

1) Expensive statement monitoring

To enable expensive statement monitoring, follow these steps:

  1. Execute transaction DB02.

  2. Navigate to 'Configuration->INI files'

  3. Expand the 'INIFILE PARAMETER LIST' node

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

  5. Double-click the' enable' node

  6. Set the value to 'true'.

2) Duration threshold for expensive statement

To set a duration threshold for expensive statement monitoring, follow these steps:

  1. Execute transaction DB02

  2. Navigate to 'Configuration->INI files'

  3. Expand the '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.

3) Resource tracking

To enable the resource tracking for monitoring, follow these steps:

  1. Execute transaction DB02

  2. Navigate to 'Configuration->INI files'

  3. Expand the 'INIFILE PARAMETER LIST' node

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

  5. Double-click 'enable_tracking' node

  6. Set the system value to 'on'.

4) Memory tracking

To enable memory tracking for monitoring, follow these steps:

  1. Execute transaction DB02

  2. Navigate to 'Configuration->INI files'

  3. Expand the 'INIFILE PARAMETER LIST' node

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

  5. Double-click 'memory_tracking' node

  6. Set the system value to 'on'.

Memory threshold for expensive statement

Since the 2211 release, this configuration parameter is not mandatory to be set for HANA Expensive statements monitoring. There is only one problem when this configuration parameter is not set, that collector for HANA expensive statements is then processing all reported expensive statements and comparing their memory sizes with collector’s parameter (DI-2305) Collector for HANA Expensive statements. If there are a lot of expensive statements reported on HANA with all memory sizes, the performance of the collector might be decreased.

To set a memory threshold for expensive statement monitoring, follow these steps:

  1. Execute transaction DB02

  2. Navigate to 'Configuration->INI files'

  3. Expand the 'INIFILE PARAMETER LIST' node

  4. Navigate to the 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.