The following SAP HANA parameters control column loads during SAP HANA startup and on the secondary system of a system replication scenario based on columns loaded into memory before the shutdown.
Parameter Name - reload_tables
Default Value - true
About Parameter -
If set to ‘true’, SAP HANA loads columns into memory during startup, which were located in memory before shutdown. This can be considered as pre-warming in order to make sure that column loads are not required when the table is accessed the first time explicitly.
How to Set Parameter - indexserver.ini -> [sql] -> reload_tables
Parameter Name - tables_preloaded_in_parallel
Default Value - 5
About Parameter -
Number of tables loaded in parallel after startup .
A higher value typically results in quicker reloads, but a higher CPU consumption, so it is a trade-off between load time and resource consumption. If you want to adjust it, you should perform some tests to find an optimal value to fulfil your needs.
How to Set Parameter - indexserver.ini -> [parallel] -> tables_preloaded_in_parallel
Parameter Name - reload_tables
Default Value - true
About Parameter -
If set to ‘true’, SAP HANA loads columns into memory during startup, which were located in memory before shutdown. This can be considered as pre-warming in order to make sure that column loads are not required when the table is accessed the first time explicitly.
How to Set Parameter - indexserver.ini -> [sql] -> reload_tables
Parameter Name - tables_preloaded_in_parallel
Default Value - 5
About Parameter -
Number of tables loaded in parallel after startup .
A higher value typically results in quicker reloads, but a higher CPU consumption, so it is a trade-off between load time and resource consumption. If you want to adjust it, you should perform some tests to find an optimal value to fulfil your needs.
How to Set Parameter - indexserver.ini -> [parallel] -> tables_preloaded_in_parallel
No comments:
Post a Comment