Memory can't release automatically in SAP HANA studio

[300221]

Hi ,

I ran sap hana studio with initial memory around 0.8G, after data preview for some sap hana view, its memory increased to 2.6 G gradually, if I exit data preview, memory taken is still that much. if I want to release memory , I have to exit sap hana studio, and restart it. is there a way to do memory release automatically?

Many Thanks,

[Cocquerel · Accepted solution]

Enable "Show heap status" under Window -> Preferences -> General. (turned off by default).

Then a heap size indicator will appear on the bottom right with a trash icon to release unused memory.

Note also that, if you have enough ressource on your workstation, you can allocate more memory to HANA Studio. For this, update the file "C:\Program Files\SAP\hdbstudio\hdbstudio.ini" and increase the values for the following parameters:

Default values:

-Xmx512m

-Xms256m

New example values:

-Xmx4096m

-Xms512m

HANA Studio restart is required