[Solved] SAP HANA – Out of Memory Caused by Large Memory Usage of Statistics Server

This case can happen if the majority of used memory by the statisticsserver occurs because of many alerts or undersized memory.

Root cause: Due to big STATISTICS_ALERTS_BASE table size, an OOM can occur.

Required Action: Check table size of _SYS_STATISTICS.STATISTICS_ALERTS_BASE and truncate STATISTICS_ALERTS_BASE from hdbsql based on solution from SAP Note 2170779 – SAP HANA DB: Big statistics server table leads to performance impact on the system


Root cause: Big Pool/Statistics allocator size

Required Action: Check SAP Note 2147247 – FAQ: SAP HANA Statistics Server first


Leave a Reply