Friday, 24 May 2019

Data Tiering Options in SAP HANA Webcast Recap

This was another great SAP User Group webcast this week.

SAP HANA, SAP HANA Study Materials, SAP HANA Guides, SAP HANA Learning, SAP HANA Certifications

SAP HANA, SAP HANA Study Materials, SAP HANA Guides, SAP HANA Learning, SAP HANA Certifications

Data tiering introduced to help manage data growth in SAP HANA

Data is rising, increasing costs, additional hardware, additional license volume

Data tiering manages data in cost efficient way

SAP HANA, SAP HANA Study Materials, SAP HANA Guides, SAP HANA Learning, SAP HANA Certifications

Native storage extension, a new feature

SAP HANA, SAP HANA Study Materials, SAP HANA Guides, SAP HANA Learning, SAP HANA Certifications

Mission critical data is in Hot (main memory tier)

Data not as critical; certain aging aspect, older data becomes less important; not accessed as often, performance not as critical as hot data

Cold data – old, voluminous (data lakes)

SAP HANA, SAP HANA Study Materials, SAP HANA Guides, SAP HANA Learning, SAP HANA Certifications

DRAM – main memory for hot data, need performance there for most important data

Persistent memory – like DRAM, available in larger sizes

Warm tier – 3 technologies – dynamic tiering, extension node has been around for a while

Native storage extension is a new feature introduced in April

Cold store – nearline storage for SAP BW been around for a while, before HANA

Hot Store, Persistent Memory


SAP HANA, SAP HANA Study Materials, SAP HANA Guides, SAP HANA Learning, SAP HANA Certifications

Developed with Intel

Persistent memory – replaces some DRAM – compared to DRAM it does not lose its data; if shut down database, and restart, persistent memory doesn’t take as long to reload data compared to DRM

Reduce total startup – from 50 minutes to 4 minutes

Increased memory capacity

DRAM – 128GB sizes, some 256 – prices increase; most common is 64GB

Persistent memory is available in larger sizes – 128GB, 256 GB, 512GB; cheaper than DRAM (per TB)

SAP HANA, SAP HANA Study Materials, SAP HANA Guides, SAP HANA Learning, SAP HANA Certifications

Also known as non-volatile memory

Two operating modes – memory mode, application does not need to be changed; still need DRAM on server, DRAM acts as cache, address data volume of persistent memory

SAP HANA – app direct mode, take advantage of technology, application will need to be changed

Application will have DRAM available

Direct access enabled file system

SAP HANA, SAP HANA Study Materials, SAP HANA Guides, SAP HANA Learning, SAP HANA Certifications

Column store main in persistent memory

Column store delta stored in DRAM

SAP HANA, SAP HANA Study Materials, SAP HANA Guides, SAP HANA Learning, SAP HANA Certifications

Size your application to handle workload

This is an example

Different ratios possible

SAP HANA, SAP HANA Study Materials, SAP HANA Guides, SAP HANA Learning, SAP HANA Certifications

Impacts on data tiering

Separates storage tier

Can keep more data in HOT with persistent memory

Not a data tiering solution but impacts it

Warm Storage, Native Storage Extension


SAP HANA, SAP HANA Study Materials, SAP HANA Guides, SAP HANA Learning, SAP HANA Certifications

Simpler landscape, integrated into server of SAP HANA

SAP HANA Cloud Services – NSE is a strategic role

Plan to make available for any SAP HANA application

Complement to other data tiering solution

Strategic solution is NSE

SAP HANA, SAP HANA Study Materials, SAP HANA Guides, SAP HANA Learning, SAP HANA Certifications

Column loadable is default

Declare partitions to page loadable

Access data on NSE will load little as possible

Buffer cache – configurable size, to buffer to pages in main memory

SAP HANA, SAP HANA Study Materials, SAP HANA Guides, SAP HANA Learning, SAP HANA Certifications

Define a whole table as page loadable

Can do on partition level (with data aging)

SAP HANA, SAP HANA Study Materials, SAP HANA Guides, SAP HANA Learning, SAP HANA Certifications

Another picture

SAP HANA, SAP HANA Study Materials, SAP HANA Guides, SAP HANA Learning, SAP HANA Certifications

Sizing and limitations

Soft limits, hope to lift limits soon, hope to before SPS05

Size of buffer cache recommendation is shown above, according to SAP’s experience

SAP HANA, SAP HANA Study Materials, SAP HANA Guides, SAP HANA Learning, SAP HANA Certifications

Tools for NSE include HANA Cockpit

Recommendation engine – can activate in HANA database to monitor query patterns executed to help you decide what is warm and partition; first step to automate data tiering in SAP HANA to make things easier

DLM is planned later this year

Warm Store new feature


SAP HANA, SAP HANA Study Materials, SAP HANA Guides, SAP HANA Learning, SAP HANA Certifications


SAP HANA, SAP HANA Study Materials, SAP HANA Guides, SAP HANA Learning, SAP HANA Certifications

Timestamp support

SAP HANA, SAP HANA Study Materials, SAP HANA Guides, SAP HANA Learning, SAP HANA Certifications

Getting started with warm store

NSE is limited to 10TB; plan to extend, plan to come close to what dynamic tiering

Which options to use


SAP HANA, SAP HANA Study Materials, SAP HANA Guides, SAP HANA Learning, SAP HANA Certifications

Data Lifecycle Management


SAP HANA, SAP HANA Study Materials, SAP HANA Guides, SAP HANA Learning, SAP HANA Certifications

Source: SAP

1 comment: