SAP HANA News by XLC
Dynamic Aging makes it possible to automatically manage at which point in time older partitions can be moved to the 'warm' data store.
The data in a new OTHERS partition is 'hot' data, that is, stored in memory with the load-unit attribute implicitly set to COLUMN LOADABLE. As an extension of the Dynamic Range Partitioning feature Dynamic Aging makes it possible to automatically manage when older partitions can be moved to the 'warm' data store (Native Storage Extension) with the load-unit attribute for the partition set to PAGE LOADABLE. Warm data is then stored on disk and only loaded to memory when required.
Dynamic Aging can be used with both THRESHOLD mode (defining a maximum row count number in partition OTHERS) and INTERVAL mode (defining a maximum time or other numeric interval between each new partition). For example, for a partitioned table which is managed by dynamic partitioning and containing date/time information, you can specify an age limit (for example six months) so that when data in an ol
You can create partitions with a dynamic others partition by including the DYNAMIC keyword in the command when you create the partition, this can be used with either a THRESHOLD value to define a maximum row count number or an INTERVAL value which can be used to define a maximum time or other numeric 'distance' value. The partition can be either a single level or a second level RANGE partition and dynamic ranges can be used with both balanced and heterogeneous partitioning scenarios.
For heterogeneous partitioning schemas Dynamic Range Partitioning is available to support the automatic maintenance of the 'others' partition.
When you create an OTHERS partition there is a risk that over time it could overflow and require further maintenance. Using the dynamic range feature the others partition is monitored by a background job and will be automatically split into an additional range partition when it reaches a predefined size threshold. The background job also checks for empty partitions and if a range partition is found to be empty it is automatically merged to neighboring empty partitions (the others partition is never automatically deleted).
A success story regarding BW/4HANA and different data tiering and optimization methodes.
1) Removed overhead in key attributes which reduced the PK size (often more than 50% of the overall table size)
2) optimized the partitioning design
3) used NSE for write optimized ADSOs
4) introduced NSE for several ADSOs
5) optimized usage of inverted individual indexes
ACDOCA table growth - how to handle it in a S/4HANA system
SAP HANA 2.0 SPS08 Roadmap and features Q4 2024
SAP HANA scaling and tuning with proper partitioning designs
End of maintenance for HANA 2.0 SPS05 in 2025 - plan your upgrade path
SAP HANA 2.0 SPS08 was released to customers at the end of November 2024. The release has 4 years of maintenance. In parallel, SPS05 will remain under maintenance until December 2025 and SPS07 until April 2028.
Feedback of customer projects and the labyrinth of the roles & responsibilities list