HANA Alerts

[Former Member]

Hi,

In HANA Studio when i go to Alerts tab, its taking more than 5 mins to respond and show the alerts information. If i execute below command, its the same behaviour.

hdbsql -U b -j "select count(*) from _SYS_STATISTICS.STATISTICS_CURRENT_ALERTS"

FYI: HANA Server is configured with 1TB memory and i dont see any high CPU/memory usage while running this command or while opening from Studio.

Can someone please let me know what to do to get the response very fast.

Is it possible to purge the old hana alerts?

Regards,

Praveen Chanda

[former_member182967]

Hello Praveen,

Check this note 2170779 - SAP HANA DB: Big Statistics Server Table STATISTICS_ALERTS_BASE Leads to Performance Impact on the System

Regards,

Ning Tong

[Former Member]

Hi Praveen,

Alerts can be cleared by following statement

ALTER SYSTEM CLEAR TRACES('ALERT');

More information:

ALTER SYSTEM CLEAR TRACES - SAP HANA SQL and System Views Reference - SAP Library

Gopal