Hello Experts,
What can I do to reduce the memory or CPU consumption of CHECK_TABLE_CONSISTENCY?
Kindly share your valuable views here.
Updated May 18, 2018
Hello Experts,
What can I do to reduce the memory or CPU consumption of CHECK_TABLE_CONSISTENCY?
Kindly share your valuable views here.
Comments
You can consider the following options to reduce memory and CPU consumption of CHECK_TABLE_CONSISTENCY:
Action
Reduce parallelism
Details
Reduce the amount of concurrently analyzed tables by adjusting the parameter indexserver.ini -> [table_consistency_check] -> check_max_concurrency.
If you use the embedded statistics server for the consistency check, the default parallelism (indexserver.ini -> [table_consistency_check] -> internal_check_max_concurrency) is already rather low and can be adjusted if required.
Action
Use recent patch level
Details
In general newer SAP HANA Revisions will contain optimizations in terms of memory and CPU consumption for CHECK_TABLE_CONSISTENCY. An important improvement was introduced with Rev. 97.03 and Rev. 102.01 where certain checks are processed chunk-wise rather than on global column / table level.
Action
Run consistency check on table level
Details
As a last resort you can consider to run CHECK_TABLE_CONSISTENCY on table level rather than globally, so that you can force a sequential execution of checking different tables:
CALL CHECK_TABLE_CONSISTENCY('CHECK', '<schema_name>', '<table_name>');