(DI-2202) Collector for HANA Save Point performance

The technical name of the Collector for HANA Save Point performance is /DVD/MON_HDB_CL_COL_SP.

This collector collects information about Save Point performance according to the view M_SAVEPOINTS. During a save point, the database system writes data which has changed since the last save point from the data cache (working memory) to the data area (permanent storage). The data written during a save point always represents a consistent state of the database. During a save point, the database system does not overwrite the pages written to the data area at the previous save point, but instead writes the changed data to free positions. This is because the database system requires this information from the previous save point for a restart to check if there is a system failure during the new save point. Only after the database system has successfully completed the new save point, it releases the pages of the old save point in the data area for overwriting. To perform a save point write operation, SAP HANA needs to take a global database lock. This period is called the critical phase of a save point.

Default KPIs delivered with this collector

The following default KPIs are delivered with this collector: