How can I Monitor the Progress of CHECK_TABLE_CONSISTENCY?

Consistency check activities can be monitored in the following ways:

Tables:

M_SERVICE_THREADS
M_SERVICE_THREAD_SAMPLES
HOST_SERVICE_THREAD_SAMPLES

SQL statement :

SQL: "HANA_Threads_CurrentThreads"
SQL: "HANA_Threads_ThreadSamples_FilterAndAggregation"
SQL: "HANA_Threads_ThreadSamples_AggregationPerTimeSlice"

Details:

Consistency check related thread information can provide insight which tables are currently checked and what kind of detailed activity is executed. See SAP Note 2114710 for more information.

Tables:

M_JOB_PROGRESS

SQL statement :

SQL: "HANA_Jobs_JobProgress"

Details:

Starting with SAP HANA SPS 10 the view M_JOB_PROGRESS contains information for the current table consistency check related activities (JOB_NAME = 'Check Table Consistency').