SAP Hana - Savepoint

Sap Hana Architecture

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





Discover More
Sap Hana Studio Hdbconsole
HANA - HdbCons (DB Management Client Console)

The SAP HANA database server management console (hdbcons) is an expert HANA management tool. Command client on the server. Per default hdbcons will connect to the indexserver process where: pid...
Sap Hana Architecture
SAP Hana - Data and Log Volume (File)

Each volume contains one file (datavolume_0000.dat) in which data is organized into pages, ranging in size from 4KB to 16MB (page size class). During the installation process, the following default...
Sap Hana Architecture
SAP Hana - Database Start/Stop/Restart

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...
Sap Hana Studio Administration Landscape
SAP Hana - Services (Process)

An SAP HANA system consists of multiple services In order to persist data to disk, each SAP HANA service (that persist data ie nameserver, indexserver, xsengine) has its own separate savepoints. ...
Sap Hana Architecture
Sap Hana - (Redo) Log

Redo log entries (in-memory) are written to the log volumes consistently for all changes to persistent data. While logging is disabled no log entries will be persisted, only the data area will...
Sap Hana Architecture
Sap Hana - Data Persistence

SAP HANA persists in-memory data by using savepoints operation in data volume (file). Whenever a Savepoint or a Snapshot is created or a delta merge is performed, data is persisted from memory to the...
Sap Hana Architecture
Sap Hana - Snasphot

The SAP HANA database snapshots are used by certain operations like: backup and database copy. They are created by triggering a system wide transactional consistent savepoint. The system keeps the...
Hana Column Store Write Read Operations
Sap Hana - Table Column - Column Store

Table column. Data Structure Access Pattern Compression Main Storage Optimized for read access Advanced Delta Storage Optimized for write access Basic Read operations are performed on...



Share this page:
Follow us:
Task Runner