0

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?

EDIT:

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

1

easy :-)

truncate table _SYS_STATISTICS.STATISTICS_ALERTS_BASE;

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.

3
  • 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 .