SAP HANA News by XLC
![More time to switch from BSoH to S/4HANA](https://le-cdn.website-editor.net/32f0386e38ce4974ba4736c429a10097/dms3rep/multi/opt/qiZHIjgW-1920w.jpg)
![Performance degradation after upgrade to SPS07](https://le-cdn.website-editor.net/32f0386e38ce4974ba4736c429a10097/dms3rep/multi/opt/Bildschirmfoto+2023-12-12+um+07.50.13-1920w.png)
![Optimize your SAP HANA with NSE](https://le-cdn.website-editor.net/32f0386e38ce4974ba4736c429a10097/dms3rep/multi/opt/1736886408488-1920w.png)
![SAP HANA NSE - a technical deepdive with Q&A](https://le-cdn.website-editor.net/32f0386e38ce4974ba4736c429a10097/dms3rep/multi/opt/NSE_read-write-ratio-1920w.png)
![Proactive maintenance for SAP RISE will start now in 2025](https://le-cdn.website-editor.net/32f0386e38ce4974ba4736c429a10097/dms3rep/multi/opt/RISE_proactive_maintenance-1920w.png)
![Dynamic Aging for NSE - combined with Threshold and Interval option](https://le-cdn.website-editor.net/32f0386e38ce4974ba4736c429a10097/dms3rep/multi/opt/Dynamic_Range_Dynamic_Aging-1920w.png)
![automatic maintenance of the 'others' partition](https://le-cdn.website-editor.net/32f0386e38ce4974ba4736c429a10097/dms3rep/multi/opt/Dynamic_Range_interval_option-1920w.png)
![HANA Range Partitioning details](https://le-cdn.website-editor.net/32f0386e38ce4974ba4736c429a10097/dms3rep/multi/opt/Partitioning_threads-1920w.png)
![A success story regarding BW/4HANA and different data tiering and optimization methodes.](https://le-cdn.website-editor.net/32f0386e38ce4974ba4736c429a10097/dms3rep/multi/opt/BW+data+tiering+-+a+success+story-1920w.png)
Please contact us if you face any kind of HANA performance issues.
If your are running HANA SPS5 or SPS06 (>Rev65) with an ABAP stack with one of the affected kernels you have to follow the instructions provided by SAP or contact XLC.
It is important if you use the new kernel wit the fix, you have to regenerate the ABAP loads via SGEN of the impacted code.
If you use the SPS06 workaround, you have to clear the SQL plan cache after implementing the parameter:
ALTER SYSTEM ALTER CONFIGURATION ('indexserver.ini', 'SYSTEM' ) SET ('sql', 'prefer_cs_itab_in_subquery_for_param_itab') = 'true' WITH RECONFIGURE COMMENT 'SAP Note 3149562. <ADDITIONAL ACTION: Revert after upgrade to a revision containing the fix>';
ALTER SYSTEM CLEAR SQL PLAN CACHE;A