(DI-2208) HANA Configuration file setup

Owned by SNP
Jul 29, 2022
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 '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

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

  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.

3) Memory threshold for expensive statement

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

  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.

4) Resource tracking

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

  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'.

5) Memory tracking

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

  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'.