SAP Knowledge Base Article - Preview

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

Symptom

  • 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 mass changes or when there is a resource bottleneck in the system due to high load several occurrences of this alert may occur in parallel.
  • In revisions lower then 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.

Read more...

Environment

SAP HANA Database

Product

SAP HANA, platform edition all versions

Keywords

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 , SV-PERF , Performance Messages , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.