cancel
Showing results for 
Search instead for 
Did you mean: 

HANA tables load monitoring - during restart

former_member201054
Contributor
0 Kudos

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

View Entire Topic
Cocquerel
Active Contributor

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
Explorer
0 Kudos

n/a

iurii_tiunov2
Explorer
0 Kudos
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?