Symptom
You find that the during some specific time, the free memory of HANA system becomes scarce and there is frequent Unloads and Shrink information reported. And you want to find which SQL is responsible for this.
HANA Alert Information:
Indexserver trace:
2023-03-24 09:33:32.371678 w ResMan ResourceContainerShrink.cpp(02478) : Information about shrink at 2023-03-24 09:33:32 360 Local:
Reason for shrink: Reserve for xxx, user size: 1048576
ShrinkCaller
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 1.0
- SAP HANA Database 2.0
Product
Keywords
SQL; memory; allocated memory size; unload; Shrink; , KBA , HAN-DB-PERF , SAP HANA Database Performance , 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.