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!

Thorsten Niehues
  • 261
  • 3
  • 6
  • 13

1 Answers1

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.

Florenz Kley
  • 185
  • 8