SAP Hana - Savepoint

About

SAP HANA persists in-memory data by using savepoints. Each SAP HANA service has its own separate savepoints.

You must always ensure that there is enough space on the disk to save data and logs. Otherwise, a disk-full event will occur and the database will stop working.

Operation

During a savepoint operation, the 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.

Frequency

The frequency at which savepoints are defined can be configured in the persistence section of the global.ini file (every 5 minutes by default).

Events

Savepoints are also triggered automatically by a number of other operations such as:

Manually

You can trigger a savepoint manually by executing the following statement

ALTER SYSTEM SAVEPOINT

Data Dictionary

Documentation / Reference


Powered by ComboStrap