Tuesday 9 February 2021

Use Of Save Point Mechanism In SAP HANA Database | Techrelam


Use Of Save Point Mechanism In SAP HANA Database  

SAP HANA database persists in-memory data by using savepoints. Each SAP HANA service has its own separate savepoints. During a savepoints operation, SAP HANA database flushes all changed data from memory to the data volumes. The data belonging to a savepoint represents a consistent state of the data on disk and remains so until the next savepoint operation has completed. Redo log entries are written to the log volumes for all changes to persistent data. In the event of a database restart the data from the last completed savepoint can be read from the data volumes, and the redo log entries written to the log volumes since the last savepoint can be replayed. The frequency at which savepoints are defined can be configured in the persistence section of the global.ini file (every 5 minutes by default). Savepoints are also triggered automatically by a number of other operations such as data backup, and database shutdown and restart. 


EmoticonEmoticon

Note: only a member of this blog may post a comment.