Optimization of system resources with HANA data tiering


The total cost of ownership (TCO) also increases as a result of constantly growing systems and the resulting increased requirements for system resources. With features such as NSE (Native Storage Extension) it is possible to optimize this.

Reduction of the TCO

Braking system growth

low loss of performance

no additional add-ons / license changes required

HANA Workload

Q1 / 2022 - Q4 /2022:

Extreme growth in the main memory area, as well as increased CPU load.


Q1 / 2023:

The use of HANA Workload Management was able to drastically reduce and stabilize the CPU load.


Q2 / 2023:

By page out the tables via NSE (Native Storage Extension), more than 20% memory could be saved in the sizing.
Data Tiering - NSE Potential

without data tiering:

An initial sizing with a 1:1 distribution of payload to working space


with archiving:

The implementation of archiving concepts is lengthy and cannot be applied to all objects. Unused data should be moved out of HANA.


With NSE:

NSE serves as a supplement to archiving and can very quickly contribute to the optimization of resources. The data remains part of the HANA. It can also be used independently of archiving.

Potential: 20-30% of sizing


Optimal data tiering:

Both solutions (archiving + NSE) complement each other and should be used together.

NSE Candidates

  • many changes (writes = insert, delete, update etc.)
  • few read operations (reads)
  • currently no core components possible (ACDOCA)

NSE Step-by-Step


  • Analysis of the candidates with leverage
  • NSE design (determination of which level is worthwhile)
  • Sizing of the buffer cache
  • Performance review of the defined KPIs
  • Operation and expansion of NSE


Concerns about using NSE?

We test it for you!

In a temp. Cloud environment we play the original workload of your prod. HANA system and provide you with exact results about the behavior of NSE with your workload in particular.

NSE test case in the cloud

NSE savings of recent projects

  • number of prod. systems: 36
  • number of systems: 170+
  • Solutions: S/4, ERP 6.0, BW/4HANA, CAR, F&R


as of 09 / 2023

All important serviOne-stop services for everything to do with HANA.

With our range of services, we also meet the most individual requirements.
Do you want to implement a HANA project with internal resources, but still secure yourself? Simply bring us in at certain milestones in order to supplement the expertise of your colleagues.
Request services
Share by: