Symptom
This Knowledge Base Article (KBA) is part of a series of HANA Operation Recommendations.
Its focus is on providing best practice instruction on handling HANA Alerts related to How to Handle Alert ‘Table growth of non-partitioned column-store tables’ (Alert ID 20 - Table growth of non-partitioned column-store tables).
This check determines the total memory size for table growth of not partitioned column table.
Its focus is on providing best practice instruction on handling HANA Alerts related to How to Handle Alert ‘Table growth of non-partitioned column-store tables’ (Alert ID 20 - Table growth of non-partitioned column-store tables).
This check determines the total memory size for table growth of not partitioned column table.
Environment
SAP HANA Database SPS 08 and higher.
Instructions in this Knowledge Base Article have been created on a SAP HANA Database Revision 81 (Support Package Stack SPS08) and may differ in other revisions.
Instructions in this Knowledge Base Article have been created on a SAP HANA Database Revision 81 (Support Package Stack SPS08) and may differ in other revisions.
Cause
This alert would be triggered when following prerequisites are met for column tables.
- The column table is not partitioned.
- The column table has a significant growth over the last hour.
- Initial load of data into HANA system.
Resolution
Complementary to the steps below it is recommended to define required
communication between basis teams and application/end-user teams on:
For a more detailed description refer to the attached document.
- Communication of schedule and data volume of planned data loads
- Communication and authorities in case a load has to be terminated
- Check Alerts
- Check column store memory size in total
- Optimize Table Partitioning
- Consider to split the column table into partitions.
- SAP HANA Studio - SAP HANA Administration Console – Alerts
- SAP HANA Studio - SAP HANA Administration Console – Open SQL Command
- SAP HANA Studio - SAP HANA Administration Console – Landscape – Redistribution
- SAP HANA Studio - SAP HANA Administration Console – Performance - SQL Plan Cache
For a more detailed description refer to the attached document.
See Also
SAP HANA Guides
- SAP HANA Administration Guide
- SAP HANA SQL and System Views Reference
- SAP HANA Troubleshooting and Performance Analysis Guide
- 1909763 - How to handle HANA Alert 17: ‘Record count of non-partitioned column-store tables’
- 2044468 - FAQ: SAP HANA Partitioning
- 1977268 - How to handle HANA Alert 40: 'Total memory usage of column-store tables'
- 1969700 - SQL statement collection for SAP HANA
Keywords
SAP HANA
Alerts
Column Store
Table
Growth
Memory
Alerts
Column Store
Table
Growth
Memory
Header Data
Released On | 25.02.2015 15:22:16 | ||
Release Status | Released to Customer | ||
Component | SV-BO-DB-HAN Backoffice Service Delivery - DB/HANA Performance | ||
Priority | Normal | ||
Category | Problem | ||
Database |
|
How to make point 3 and 4? thanks
ReplyDeleteworld777 dl
ReplyDeleteluxurious property of jaipur
best coaching classes for class 10 in gurgaon
kurti sharara set
traditional kurtis for women
azure firewall
azure blueprints
azure resource group
azure application gateway
azure express route