HANA News Blog

SAP HANA 2.0 SPS08 Roadmap

Jens Gleichmann • Sept. 13, 2024

The latest features of HANA 2.0

The roadmap via Road Map Explorer was recently updated and some interesting features jumped into the spotlight. Some of them are already known because they are already implemented in HANA 4.0 (HANA Cloud).

The interesting topics with important changes are: partitioning, data tiering (NSE), security, optimizer, backup and XSA. No, you won't hear any machine learning or AI features from me. If you really want and need them, because there are some, please go to Road Map Explorer :)


Partitioning


  • Support for a generated column as a partitioning key
  • Support for heterogeneous HASH-RANGE partitioning

=> currently HASH-RANGE was only possible for non-heterogeneous / homogeneous partitioning, so it was not possible to use the dynamic range interval option - a great one!


  • Support heterogeneous partitioning into three levels for the following partitioning types:
  • RANGE-RANGE-HASH
  • RANGE-RANGE-RANGE

=> some of you may noticed that some monitoring views in SPS07 already containing some level 3 partition details

=> I'm curious to find a business case for this partition designs


Data Tiering - NSE


  • Automatic setting of the minimum-required buffer cache size of the native storage extension, as per persistence size
  • Calculate and set the UNLOAD_THRESHOLD parameter size of the buffer cache automatically based on the persistence size for data in SAP HANA native storage extension

=> SAP mean the parameter buffer_cache_cs - unload_threshold which is set by default to 80 (%)

=> Currently I don't know if this feature helps customers to size the buffer cache properly


  • Dynamic aging for range partitions to native storage extension
  • Enable for dynamic creation of a new range partition, assignment of the load unit "page-loadable" to all range partitions with a certain distance to the new partition

=>  I'm really excited to test this feature, because it will make the life of a DBA easier, if you are using NSE on partition level


  • Provide a transparent switch between column-loadable and page-loadable data without converting the persistency format
  • Significantly reduce conversion time between page-loadable and column-loadable data and, thereby, reduce business downtime and greatly simplify administration for native storage extension

=> this will make the implementation of NSE faster and easier due to lower downtimes - great feature!


Optimizer


  • Cache different SQL execution plans based on parameter values that cause variant SQL execution plans for HEX

=> this one of my most anticipated feature, because the HEX or more precise the optimizer made a lot of trouble in the past due to switching engines and the eviction of HEX plans

=> to be able to use multiple plans at a time depending on the bind variables can be a game changer in terms of performance using the HEX

=> this feature is already available since Q2 of 2024 for HANA Cloud named as SQL Plan Advisor

Source: Youtube: What’s New in SAP HANA Cloud | June 2024 | Susen Poppe and Product Experts


Security


  • Extend support for persistence, log, and backup encryption algorithms to AES 256 CTR
  • Activate TLS version 1.3 protocol by default for SQL connections for SAP HANA version 2.0 SPS 08
  • IP-based connect restriction for user groups: Ability to limit access for all users or parts of the user base, for instance, to enable only administrators to log in from the company’s IP range

=> Activating TLS 1.3 by default can create some trouble for some customers, but the implementation was more than necessary after this long time

=> the IP-based connect restriction allows to implement a SoD (Segregation of duties) concepts or helps to isolate instances


XSA


  • Improve setup of SAP HANA, extended application services, advanced model behind a reverse proxy
  • Make the solution more robust, especially during system replication takeover, as functionality of the internal system is not dependent on the external route and internal requests are “short-circuited”
  • Enable users to log in from external and internal software
  • Separate networks and DNS zones of external and internal domains
  • Hide internal back-end ports from public access by exposing the external app end points only (for example, to the public Internet) using reverse proxies

=> I'm waiting for such a feature for the "normal" HANA not only for XSA


Backup


  • Setting local secure store (LSS) as the default secure store
  • If LSS is used, inclusion of all necessary secure store backups in SAP HANA backups, eliminating the need to maintain secure store backups explicitly

=> to set LSS as default can also create some trouble and should be implemented carefully

At the end really useful features. I hope that they implement some new monitoring views for NSE and partitioning - otherwise we (XLC) will built our own solution to get the needed information collected in own history views for our customers. Due to the lack of events around the topic HANA it was not possible to provide the needed feedback for so many customers. The consequence? A lot of missing features which SAP is not aware of. Yes, there is an idea/influence page but without enough votes you can not reach your goal even if the idea is brilliant, because SAP is not aware of the need.   


SAP HANA News by XLC

HANA OS maintenance
von Jens Gleichmann 27 Sept., 2024
Please notice that when you want to run HANA 2.0 SPS07, you need defined OS levels. As you can see RHEL7 and SLES12 are not certified for SPS07. The SPS07 release of HANA is the basis for the S/4HANA release 2023 which is my recommended go-to release for the next years. Keep in mind that you have to go to SPS07 when you are running SPS06 because it will run out of maintenance end of 2023.
News for the hyperscaler AWS, GCP and MS Azure
von Jens Gleichmann 20 Sept., 2024
news instances with SAPS, memory and CPU values in comparison
Unforeseen cloud cost increases
von Jens Gleichmann 13 Sept., 2024
Unforeseen cloud cost increases - RedHat announced back in January this year that the costs for cloud partners will be changed effective April 1, 2024. They called it scalable pricing.
HANA 2.0 SPS08 Roadmap
von Jens Gleichmann 13 Sept., 2024
SAP HANA 2.0 SPS08 Roadmap Q4 2024
SUSE maintenance
von Jens Gleichmann 16 Aug., 2024
How to interpret the SUSE Lifecycle
RISE with SAP: Roles & Responsibilities
von Jens Gleichmann 24 Mai, 2024
For every possible RISE with SAP customer it is essential to know the difference of the status quo system construct (on-prem self managed / hosted or managed by a MSP) and the RISE offering with a lot of excluded tasks or tasks with additional costs. If you don't need this tasks, it might be a perfect solution, but our experience is that most customers need some of the services with extra costs.
Performance degradation after upgrade to SPS07
von Jens Gleichmann 29 Apr., 2024
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.
vm.swappiness settings
von Jens Gleichmann 24 März, 2024
The details of swapping in the context of SAP HANA
SUM tooling with target HANA
von Jens Gleichmann 18 März, 2024
Numerous IT projects such as S/4HANA projects or HANA migrations will go live over the Easter weekend. Mostly this tasks will be controlled by the SAP provided SUM tool. The SUM is responsible for the techn. migration/conversion part of the data. Over the past years it become very stable and as long as you face no new issues nearly every technical oriented employee at SAP basis team can successfully migrate also bigger systems. In former times you needed a migrateur with certification which is no longer required. As long as all data could be migrated and the system is up and running the project was successful. But what does the result look like? Is it configured according to the best recommendation and experience? Is it running optimized and tuned?No, this is where the problem begins for most companies. The definition of the project milestone is not orienting on KPIs. It is simply based on the last dialog of the SUM tool, which states that the downtime has ended and all tasks have been executed successfully.
Abstract SQL Plans
von Jens Gleichmann 13 Dez., 2023
The feature plan stability is not a new one, but can help you in case of an revision update/upgrade, if you recognize big performance degradations. But you have to activate this feature at least 1-2 weeks before the maintenance to capture the SQLs and the execution plan. You can compare the plan performance and apply the execution plan with the best performance. You can also use it as always on feature in daily operations. This may be required due to changes in data over time which may cause the query optimizer to propose different execution plans which may have a negative impact on performance and memory consumption of a query. An additional preparation step can be used to apply filters so that only specific queries are captured. In the background execution statistics are recorded so that the performance of the query can be measured and the best execution plan can
more
Share by: