2050579 - How to handle HANA Alert 68: 'total memory usage of row store' | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2050579 - How to handle HANA Alert 68: 'total memory usage of row store'

Symptom

You receive alert 'Total Memory of HANA Rowstore' (Alert ID 68). The table below gives an overview about the technical limits for the maximum size of the rowstore and the default thresholds of alerts.

Revision Technical Limit LOW MEDIUM HIGH Comment
< 80 768 GB 500 GB 600 GB 700 GB Old Statistics Server
80 - 82 ~ 1,9 TB 70 % 80 % 90 % New embedded Statstics Server (when activated)
≥ 83 ~ 1,9 TB 70 % 80 % 90 % New embedded Statstics Server (activated by default)

It is recommended to configure this alert in a way that low / medium alerts are raised for performance reason, while the priority high alert should trigger immediate action to prevent a database crash. Appropriate thresholds for very large systems should be discussed with SAP experts.

Rowstore size has a direct impact on the start-up time of any SAP HANA system and on fail-over-times in system replication and high availability scenarios, since the rowstore must be loaded to memory completely before the system is available to endusers.

Further potential issues are listed in SAP Note #1963779.

Note that data loss can occur in HANA Revisions < 69.02 or Revision 70 (also see SAP Note #1963791).


Read more...

Environment

SAP HANA Database

Keywords

SAP HANA - Operations Recommendations - Row store - Alert 68 , KBA , HAN-DB-MON , SAP HANA Monitoring , SV-PERF , Performance Messages , Problem

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.