SAP HANA Forum
What can I do to reduce the memory or CPU consumption of CHECK_TABLE_CONSISTENCY?
Kindly share your valuable views here.
You can consider the following options to reduce memory and CPU consumption of CHECK_TABLE_CONSISTENCY:
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.
Use recent patch level
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.
Run consistency check on table level
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>');
Sign up for STechies