(DI-2208) HANA Configuration file setup
1) Expensive statement monitoring
To enable expensive statement monitoring, follow these steps:
Execute transaction DB02.
Navigate to 'Configuration->INI files'
Expand 'INIFILE PARAMETER LIST' node
Navigate to following path: global.ini->expensive_statement->enable.
Double-click 'enable' node
Set the value to 'true'.
2) Duration threshold for expensive statement
To set a duration threshold for expensive statement monitoring, follow these steps:
Execute transaction DB02
Navigate to 'Configuration->INI files'
Expand '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.
3) Memory threshold for expensive statement
To set a memory threshold for expensive statement monitoring, follow these steps:
Execute transaction DB02
Navigate to 'Configuration->INI files'
Expand 'INIFILE PARAMETER LIST' node
Navigate to following path: global.ini->expensive_statement->threshold_memory
Double-click 'threshold_memory' node
Set a valid system value that is greater than zero.
4) Resource tracking
To enable the resource tracking for monitoring, follow these steps:
Execute transaction DB02
Navigate to 'Configuration->INI files'
Expand 'INIFILE PARAMETER LIST' node
Navigate to following path: global.ini->resource_tracking->enable_tracking
Double-click 'enable_tracking' node
Set the system value to 'on'.
5) Memory tracking
To enable the memory tracking for monitoring, follow these steps:
Execute transaction DB02
Navigate to 'Configuration->INI files'
Expand 'INIFILE PARAMETER LIST' node
Navigate to following path: global.ini->resource_tracking->memory_tracking
Double-click 'memory_tracking' node
Set the system value to 'on'.