How to Reduce the Memory or CPU Consumption of CHECK_TABLE_CONSISTENCY?

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>');