(DI-2311) 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 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
To set a duration threshold for expensive statement monitoring, follow these steps:
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.
3) Resource tracking
To enable the resource tracking for monitoring, follow these steps:
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'.
4) Memory tracking
To enable memory tracking for monitoring, follow these steps:
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'.
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 MEMORY_SIZE_LIMIT_IN_MB. 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:
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.