Extreme high cpu load (2998%) hbdindexserver

[Former Member]

Hello gurus

One of our servers running HANA has an extreme high cpuload.

All our CPU's are on 100% and when I run the top command I get the following result:

HANA studio is not accessible anymore. We've already tried rebooting the server and database...

Do any of you have a suggestions or had a similar issue?

Many many thanks in advance,

Kind regards,

Bart

[davidebruno · Accepted solution]

can you copy here the content of

indexserver_<host>.trc

from /usr/sap/<SID>/HDB<SYSNUM>/host/trace

for example?

you can view what threads are executed with the query

select current_time, THREAD_ID,connection_id,PORT,HOST,SERVICE_NAME,THREAD_TYPE,THREAD_METHOD,substr(THREAD_DETAIL,1,40) threadDetail, thread_state ,application_user_name, caller,calling,DURATION from m_service_threads where thread_state <> 'Inactive' or thread_method like 'Backup%' order by service_name, connection_id

[prudhvi_ravipati · Accepted solution]

Dear All,

Is there is any solution to resolve this Issue ?. As during my busy time server are been hanging due to high CPU usage.
Thanks for advising,

Regards,
Prudhvi.