HANA Savepoints

Purpose

A savepoint ensures that all changed persistent data since the last savepoint gets written to disk. The SAP HANA database triggers savepoints in 5 minutes intervals by default. Data is automatically saved from memory to the data volume located on disk. Savepoints run asynchronously to SAP HANA update operations. Database update transactions only wait at the critical phase of the savepoint, which is usually taking some microseconds.

This dashboard gives and overview and potential issues during this process.

Example:

Savepoints

Shows overall number of finished savepoints for all DB servers.

Savepoint performance

Shows speed of savepoint write process in MB/s, should be at least 100MB/s.

Savepoints duration

Maximum duration of savepoints in the given period. Total savepoint duration should be less than 900 seconds.

Critical phase of a savepoints should always take less than one second, during this phase the overall DB is locked for changes.

Time since last savepoint

Shows delay in savepoints, must be always less than 900 seconds.