SAP HANA Dynamic Tiering

SAP HANA dynamic tiering adds smart, insightful, disk-based extended storage to your SAP HANA database Administration. In HANA database Administration Dynamic, tiering amplifies SAP HANA with large loads & volumes of warm data management potential.

A multistore table in SAP HANA Administration is referred to as a partitioned SAP HANA table that possesses at least a single partition in SAP HANA contrary to any other partitions in dynamic tiering extended storage. Dynamic tiering in SAP HANA Administration provides extended storage as a replacement or an alternate physical store for SAP HANA table partitions. Whereas Multistore tables are managed and tracked just like other columnar tables, but they offer the support of disk-based storage for less regularly accessed data through extended storage in HANA Administration.

Hot data is important, frequently obtained business data; warm data is reached less frequently, and is less worthwhile. By adopting dynamic tiering to set hot data in SAP HANA in-memory tables, and warm data in both extended tables and multistore tables, the most eminent value data remains in-memory, and cooler less-valuable data is cached in the extended store. This can lessen the size of your in-memory database.

The following are the available features:

• Database Services
• Store and access data

In SAP HANA Administration, the database services store warm data on disk, in compressed format, in either extended tables or multistore tables. The Multistore tables in SAP HANA Administration database have at least one partition in SAP HANA, and other partitions in extended storage. The data can be moved between extended tables, multistore tables, and HANA tables.

We can move data into column-based extended tables from an external source or move data into partitioned multistore tables from an external source. Tables in extended and multistore can be managed by using SQL or graphical tools in HANA Database Administration. The Tables present in Extended and Multistore can be monitored by using the graphical tool.

We can Convert SAP HANA tables to extended or multistore tables as per the demand.Data can be loaded using all the data provisioning technologies supported by SAP HANA including (but not limited to) SAP HANA smart data integration, and the SAP Landscape Transformation Replication Server (SAP SLT).

Provision database

Installing the dynamic tiering portion of an SAP HANA system as a part of SAP HANA Administration task and configuring the dynamic tiering component as part of an overall SAP HANA system landscape. Refresh the SAP HANA dynamic tiering component of an SAP HANA system landscape and Provide user authorizations for different levels of data access by Ensuring high availability and disaster recovery.

To ensure the disaster recovery we need to implement backup and recovery mechanisms to the HANA Database and ensure disaster recovery, including point-in-time recovery where we mention a particular time and date.

Automatic failover is enabled in the tenant database in SAP HANA systems. We can Use system replication to conserve a secondary dynamic tiering system for fault and disaster recovery support.

We at Ripples Info provide exclusive and more elaborative knowledge in SAP HANA 2.0 SPS 05 Administration Online Training .Practical’s are provided on our LIVE SERVERS for all the High-End Topics like Disaster Recovery, Auto Failover, SLT, DXC to name a few. So to Stay ahead enroll today for our SAP HANA Administration Online Training by Mr. Mallikarjun Jammula HANA Architect with 19 years of SAP Experience.