SAP Knowledge Base Article - Preview

1909742 - How to handle HANA Alert 19: ‘Record Count of Delta Storage of Column-Store Tables'

Symptom

When checking the Alerts tab in HANA there is an alert called “SCHEMANAME.TABLENAME has 79533 records in delta memory (9 columns)”

  • For HANA Studio, you would find the alert by going to Administration Console -> Alerts -> Show: all alerts.

1.png

  • For Solution Manager, you would find the alert using transaction DBACOCKPIT -> choose HANA system -> expand Current Status -> Alerts

To check the exact time please go to Administration Console -> Alerts -> double click on the Alerts

2.jpg

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental


Read more...

Environment

SAP HANA Database

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition all versions

Keywords

delta memory; Mass write operations; compression algorithms; delta merge; Forced merge; Memory-only merge; Hard merge; , KBA , HAN-DB-MON , SAP HANA Monitoring , SV-PERF , Performance Problems , Problem

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.