Sap Hana - Memory Management for services

About

Memory Management for services

SAP HANA resource usage

SELECT 
     service_name, 
     database_name,
     round(effective_allocation_limit/1024/1024/1024, 1) AS MemLimit, 
     round(total_memory_used_size/1024/1024/1024,1) AS MemUsed 
FROM "SYS_DATABASES".m_service_memory

If the MemUsed is close to the MemLimit , you may encounter problems allocating memory.

Alternatively, you can run the Linux free command at the command line to see the free memory resources:

free -g
             total       used       free     shared    buffers     cached
Mem:             6          3          3          0          0          1
-/+ buffers/cache:          1          4
Swap:            2          0          2

The key number is in the second row (-/+ buffers/cache) in the free column. If this number is low, (e.g. 1 GB) you may have run out of memory when performing your recent operation.


Powered by ComboStrap