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 (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!

1 Answer 1


easy :-)


have a look at SAP note 2170779. I usually have a cron job getting rid of older alerts with the "delete older entries" statement described in the note.

  • Thx for the reply. Probably I tried with the wrong user (permission denied) Commented Feb 19, 2016 at 14:48
  • Thx esp. for the SAP note :) Commented Feb 19, 2016 at 14:49
  • bitte sehr... auch wenn "everything HANA" ganz schrecklich verteilt ist lohnt sich das gute alte OSS immer noch. Commented Feb 25, 2016 at 19:16

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .