When and where should consistency checks be scheduled?
Updated May 19, 2018
When and where should consistency checks be scheduled?
Comments
23 Jun 2015 1:18 pm Sushma Best Answer
Consistency checks can block read and write operations on tables while they are running and usually have high CPU and memory consumption, so you should run them during a down-time or during non-critical time frames. If possible you can perform the check on recent copies of the production system and not on the production system itself.
It is not possible to run consistency checks like CHECK_TABLE_CONSISTENCY or CHECK_CATALOG on secondary sites of SAP HANA system replication environments, because these checks require read access to tables and this is currently not possible on the secondary site.
Consistency checks can block read and write operations on tables while they are running and usually have high CPU and memory consumption, so you should run them during a down-time or during non-critical time frames. If possible you can perform the check on recent copies of the production system and not on the production system itself.
It is not possible to run consistency checks like CHECK_TABLE_CONSISTENCY or CHECK_CATALOG on secondary sites of SAP HANA system replication environments, because these checks require read access to tables and this is currently not possible on the secondary site.