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
All the site contents are Copyright © www.stechies.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies. The site www.stechies.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity. Information used on this site is at your own risk.
The content on this site may not be reproduced or redistributed without the express written permission of
www.stechies.com or the content authors.