HANA News Blog

End of maintenance for HANA 2.0 SPS05 in 2025

Jens Gleichmann • 21. November 2024

End of maintenance HANA SPS05 *updated*

HANA 2.0

 

Planen Sie zum Ende 2025 den Upgrade auf HANA 2.0 SPS07 oder SPS08 (Release 11/2024), sollten Sie sich aktuell auf SPS05 befinden. Bitte beachten Sie die unterstützten Betriebssysteme und planen Sie den OS Update/Upgrade mit ein!

Sie können von SPS05 direkt auf SPS08 wechseln. Beachten Sie hier bitte den Update-Pfad.

Sowohl die Parameter, als auch die Änderungen in Features / Engines haben Einfluss auf die Stabilität und Performance.

Wir unterstützen Sie bei der Validierung für ein optimales Ergebnis.

 

 

If you plan to upgrade to HANA 2.0 SPS07 or SPS08 (Release 11/2024) at the end of 2025, you should currently be on SPS05. Please note the supported operating systems and plan the OS update/upgrade!

You can switch directly from SPS05 to SPS08. Please note the update path here.

Both the parameters and the changes in features / engines have an impact on stability and performance.

We support you with the validation for an optimal result.

 

SAP HANA News by XLC

FAQ: SUSE Hypervisor for SAP (KVM)

von Jens Gleichmann • 14. April 2026
KVM as alternative with low TCO
inverted individual index is a special type of SAP HANA index wich can save memory

Data Tiering case study part II: Inverted Individual Indexes

von Jens Gleichmann • 6. April 2026
An inverted individual index is a special type of SAP HANA index which can only cover unique indexes. This includes all primary key structures. Unlike traditional column store indexes on more than one column (inverted value, inverted hash) an inverted individual index (Inv Idv Idx) doesn't need a dedicated concat.
Total NSE savings

Data Tiering case study part I: NSE

von Jens Gleichmann • 5. April 2026
This blog presents the results of a customer case which can be used as a reference for other implementations
SAP HANA performance issues with THP on multi-NUMA node systems

Performance issues with THP on multi-NUMA node systems

von Jens Gleichmann • 30. März 2026
SAP HANA systems may experience high swap usage, hangs, or performance issues when THP (Transparent Huge Pages) is enabled with "madvise". This occurs on multi-NUMA node systems where one or more NUMA nodes are close to full memory usage while others have plenty of free memory, and counters for THP allocations, direct
Transparent Huge Pages (THP) with madvise can trigger high swap usage and performance issues

SAP HANA & Transparent Huge Pages (THP

von Matthias Sander • 26. Januar 2026
Transparent Huge Pages (THP) with madvise can trigger high swap usage, performance issues, or even system hangs on multi-NUMA systems.
HANA performance degradation after upgrade to SPS07+SPS08

Ongoing HANA HEX performance issues with SPS07+SPS08

von Jens Gleichmann • 9. Januar 2026
With SPS06 and even stronger in SPS07 the HEX engine was pushed to be used more often. This results on the one hand side in easy scenario to perfect results with lower memory and CPU consumption ending up in faster response times. But in scenarios with FAE (for all entries) together with FDA (fast data access), it can result in bad performance. After some customers upgraded their first systems to SPS07 I recommended to wait for Rev. 73/74. But some started early with Rev. 71/72 and we had to troubleshoot many statement. If you have similar performance issues after the upgrade to SPS07 feel free to contact us! Our current recommendation is to use Rev. 74 with some workarounds. The performance degradation is extreme in systems like EWM and BW with high analytical workload.
SAP HANA NSE - a technical deepdive with Q&A

HANA NSE - technical details Q&A

von Jens Gleichmann • 24. November 2025
SAP NSE was introduced with HANA 2.0 SPS04 and based on a similar approach like data aging. Data aging based on a application level approach which has a side effect if you are using a lot of Z-coding. You have to use special BADI's to access the correct data. This means you have to adapt your coding if you are using it for Z-tables or using not SAP standard functions for accessing the data in your Z-coding. In this blog we will talk about the technical aspects in more detail.
Partitioning process

Golden Rules for HANA Partitioning

von Jens Gleichmann • 24. November 2025
SAP HANA scaling and tuning with proper partitioning designs
R+R: intersection and missing services

From Complexity to Clarity: Optimizing the R+R List for SAP Cloud ERP

von Jens Gleichmann • 25. September 2025
In transformation projects like SAP RISE / SAP Cloud ERP, the Roles & Responsibilities (R+R) list often serves as the backbone for collaboration between customer, partner, and SAP. Yet too often, this list is treated as a static document rather than a living framework. Sometimes nobody knows exactly what was defined by
Why Databases Need Optimizer Statistics – With a Focus on SAP HANA

SAP HANA data statistics for the optimizer

von Jens Gleichmann • 28. Mai 2025
In the world of modern database management systems, query performance is not just a matter of hardware—it’s about smart execution plans. At the core of generating these plans lies a critical component: optimizer statistics. This article explores why databases need optimizer statistics, with particular emphasis on SAP HANA, while drawing parallels with Oracle, Microsoft SQL Server (MSSQL), and IBM DB2.
more