SAP Knowledge Base Article - Preview

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

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

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

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.