How to free up memory in SAP HANA database | TECHRELAM

 

 

SAP HANA free up memory,

SAP HANA Appliance can be used in smarter way to achieve maximum out of it.

Based on one SAP HANA appliance is used for DEV, TRN,SDK ,,etc. Environments, definitely there will be a major issue in this case – How to handle memory as memory is limited in that particular SAP HANA appliance.

In this situation SAP HANA database manages the loading and unloading of tables into and from memory independently. Actually, the main aim of SAP HANA database is to keep all relevant data in memory. But, SAP HANA have option to do manually load and unload individual tables if necessary to free up memory.follow the below steps to unload the individual tables.it can done by SAP HANA Studio.

==>Logon into Tenant database ==> schema => Tables =>Select the table by right click and choose the option “Unload” and later, If required manually "load"the table into memory again.

This are all the options for free up memory SAP HANA DB.

1.Unload – Free up memory by unloading table from memory.
2.Load – Loading the table into memory.
3.Merge – Triggering delta merge operation for a column table.

We can free up memory using Merge operation manually trigger the delta merge operation for a column table manually in SAP HANA Studio. The delta merge operation is related to the memory management concept of the column store, and SAP HANA Database that manages data organized in columns in memory.