Optimization of SAP HANA TCO

Data is at the heart of the banking system, so optimization of their systems is vital to their operations. Explore how we helped a bank when natural growth and additional onboarding of datasets resulted in their SAP HANA hot memory being flooded.

ABOUT THE CLIENT

A data warehouse platform, with hundreds of sources, based on the data vault technique, allowing to report according to 2 timelines -a necessary condition for the regulators- and providing data to applications and European authorities.

Challenge

Data volumes were growing, and the SAP HANA hot memory was flooded by increasing data volumes, due to natural growth and the additional onboarding of datasets. As a consequence, processing memory was squeezed and out of memory and intense swapping occurred. Instability loomed, and additional investment in hardware became needed.

Approach

Analysis was performed on the read and write patterns of the data processes. A prioritised plan of steps was created, the underlying tables were partitioned and the data processes were pruned so that only the necessary data would be read. Non frequently accessed data was placed in the SAP HANA NSE warm store. Design recommendations were created to be applied to new software. This proactively helps to manage data volume growth.

Results

Hot footprint reduction (measured 1 year later, and growing) compared to ‘Do nothing’ scenario

-7 TB

No additional investment in hardware needed and not foreseen for the next years to come

- x.x00.000 EURO

Predictable, near flat –hot- data growth curve

+ PREDICTABLE

Stable system, no more out of memory or extensive swapping. Positive effect on System Operations activities

+ STABILITY

Improved perception and adoption of the reporting platform

+ BUSINESS ADOPTION
SERVICES

Optimization, modelling, simplification

INDUSTRY

Banking

TECH

SAP HANA, SAP HANA NSE, Informatica PowerCentre

Client feedback