HANA News Blog

HANA Sequences - die verborgene Handbremse im System

Matthias Sander • 31. August 2023

Nutzung von Sequences

Verwenden sie in ihren SAP HANA Systemen Sequences? Das sollte unbedingt geprüft werden. Diese können bei nicht korrekter Einrichtung die Performance einzelner SQL-Statements stark beeinflussen. Eine HANA Sequence kann mit einem fortlaufenden Nummernkreis im ABAP verglichen werden. Die Sequence generiert eindeutige, vorlaufende Nummern, die z. B. von einem HANA Trigger oder beim INSERT in eine Tabelle verwendet werden können. Ähnlich wie im ABAP können Nummern gepuffert werden. Im Standard ist der Cache jedoch auf 1 eingestellt.

 

Greifen gleichzeitig viele Operationen auf die Sequence zu, kommt es zu Wartesituation, bis die nächste Nummer vergeben wird. Durch Erhöhung des Sequence Cache kann dieses Problem gelöst werden. Hinweis: Durch den Einsatz des Caches kann es Lücken in der Vergabe geben, jedoch sind die Nummern immer fortlaufend.


Wie prüfe ich, ob Entwickler oder gar Third-Party Hersteller HANA Sequences benutzen?

Sequence im Statement erkennen:

Im Statement ist die Sequence durch die Funktion “.NEXTVAL” zu erkennen.

Beispiel mit Trigger:

Der Trigger, welcher wiederum eine Sequence verwendet, macht circa 90 % der Laufzeit des Statements aus. Hier zu sehen im Kontext der Child Prozesse.

Kernel Profiler

Statement Collector des Trigger Statements

CallStack Not Initialized   : This is a generic, unspecific semaphore name used for various semaphores in IBM on Power environments. On Intel they follow the naming convention "<module>.cpp: <function>" instead, e.g. "DeltaIndexManager.cpp: TRexAPI::DeltaIndexManager::MergeAttributeThread::MergeAttributeThread".

Mittels Kernel Profiler kann ermittelt werden, was genau die DB in diesem Status macht. Das gilt auch für andere Fälle.

3,88s Wartezeit

Davon entfallen über 90% auf die HANA Sequence

Beim konkreten Kundenfall hatte das folgenden Effekt:

Peakzeiten vor Caching: 160ms pro Ausführung

Peakzeiten nach Caching: 1ms pro Ausführung


Im täglichen Durchschnitt sieht der Ergebnis folgendermaßen aus:

SAP HANA News by XLC

Performance degradation after upgrade to SPS07
von Jens Gleichmann 5. November 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.
HANA OS maintenance
von Jens Gleichmann 29. Oktober 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.
HANA Roadmap
von Jens Gleichmann 24. Oktober 2024
End of maintenance for HANA 2.0 SPS05 in 2025 - plan your upgrade path
News for the hyperscaler AWS, GCP and MS Azure
von Jens Gleichmann 20. September 2024
news instances with SAPS, memory and CPU values in comparison
Unforeseen cloud cost increases
von Jens Gleichmann 13. September 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. September 2024
SAP HANA 2.0 SPS08 Roadmap Q4 2024
SUSE maintenance
von Jens Gleichmann 16. August 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.
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.
more
Share by: