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?