SAP Knowledge Base Article - Preview

3327014 - How to check the responsible SQL loaded large size data into memory


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

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



  • SAP HANA Database  1.0
  • SAP HANA Database  2.0


SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0


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.