About
Memory Management for services
Articles Related
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.