1977314 - How to handle HANA Alert 29: 'Size of delta storage of column-store tables'

• You receive HANA alert 'Size of delta storage of column-store tables' (Alert ID 29). The alert is triggered for individual tables.
• In case of massive changes or there is a resource bottleneck in the system due to high load, several occurrences of this alert may occur in parallel.
• In revisions lower than 83, the alert often occurs along with alert 'Record count of delta storage of column-store tables' (Alert ID 19). Both alerts can be processed together since they reflect mostly the same root cause.
  Alert ID 19 is going to be suspended in the new Embedded Statistics Server.
• Solution Manager EWA (EarlyWatch Report) alerts to "The delta size of one or more column store tables exceeds 10 GB or records in Delta Store are not merged within 28 days."

SAP HANA Database

Operations Recommendation; #OpsRec-HANA; Mass write operations; bottleneck; delta merge operation; sizing; check_interval; mergedog; M_CS_TABLES; MERGE_COUNT; merge statistics; auto-merge;Table Partitioning; available memory; delta merges; , KBA , HAN-DB-MON , SAP HANA Monitoring , HAN-DB , SAP HANA Database , HAN-DB-PERF , SAP HANA Database Performance , SV-PERF , Performance Problems , How To