HANA tables load monitoring - during restart

[former_member201054]

Hi Experts,

How can we check the HANA tables loading status into memory after every restart?

* Is there any SQL command?

* How to identify the number of tables supposed to be loaded after every restart?

Please answer.

Thanks in advance

[Cocquerel · Accepted solution]

You can monitor the column store load using SQL: "HANA_Jobs_JobProgress" (JOB_NAME = 'Column table reloading on startup') available via SAP Note 1969700.

The default restart strategy (indexserver.ini -> [sql] -> reload_tables = true) is to reload all columns that were in memory at the time of the shutdown.

[iurii_tiunov2 · Accepted solution]

n/a

[iurii_tiunov2 · Accepted solution]

Hello Cocquerel, do you know is any estimation tool/method exists to calculate timing then all columns will be loaded into memory after HANA startup?

[AtulKumarJain]

Hi,

You can try to check In the Runtime Information tab, select the M_CS_TABLES view.

Best Regards,

Atul