Symptom
- No partition in the system can be fully unloaded from memory as continuous read access across all partitions preventing the unloading.
- Table design or access patterns inherently keep partitions active, preventing them from becoming inactive or rarely used.
- Memory behavior is observed where all partitions are actively accessed.
- Inquiry about recommended partitioning strategies for memory optimization.
- Inquiry about alternative partitioning approaches besides hash partitioning for effective memory management.
- Inquiry about best practices to optimize partitioning and reduce memory footprint in high-read scenarios.
Read more...
Environment
- SAP HANA DB Engines
- SAP Advanced Track and Trace for Pharmaceuticals
Product
SAP Advanced Track and Trace for Pharmaceuticals 3.0 ; SAP Advanced Track and Trace for Pharmaceuticals on SAP S/4HANA 2310
Keywords
SAP HANA, memory behavior, partitioning strategies, hash partitioning, memory optimization, partitioned tables, high-read scenarios, table design, access patterns, memory management, best practices, unload partitions, continuous read access , KBA , IS-PHA-ATT , SAP Advanced Track and Trace for Pharmaceuticals , HAN-DB-ENG , SAP HANA DB Engines , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview