hana db data Load/Unload

Q1. If HANA is terminated abnormally, at what point is the content in memory written to DISK?
A1. All modified pages of row and column store are written to disk during a savepoint.
The default value of savepoint_interval_s is 300, so savepoints are taken in intervals of 300 seconds (5 minutes).

global.ini

 
Q2. After creating a new table, at what point will this table be loaded in-memory?
A2. When a table column is accessed and it doesn't reside in memory yet, it is loaded into memory.
 
You can check the table load and column load status with these SQL.

select TABLE_NAME, LOADED from M_CS_TABLES where TABLE_NAME=’<table name>’ select TABLE_NAME, LOADED from M_CS_COLUMNS where TABLE_NAME=’<table_name>’

 
 
관련 URL : https://help.sap.com/docs/SAP_HANA_PLATFORM/6b94445c94ae495c83a19646e7c3fd56/c133165bbb57101493c5fb19b5b8607f.html