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

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.

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.