Our SAP HANA database consumes a lot of memory - even though we do not have much data in it.
After some research:
select top 100 * from M_CS_TABLES order by MEMORY_SIZE_IN_TOTAL desc
I figured out that the STATISTICS_ALERTS_BASE table has a size of over 20.000.000.000 (twenty billion)
How to reduce or clear this table?
If the table gets huge it can make the admin panel in SAP HANA really slow. If so then truncate the table fixes the issue!