Runtime dump on SAP HANA

Here , I Explained about How to generate a runtime dump on SAP HANA .Sometimes the production systems will have high CPU/Memory consumption and this might lead to the index-server taking lot of time to execute the requests so we need to find out, where the index-server is being used so for this purpose, SAP Support may ask us to run the "runtime dumps"

To execute this , there is a SAP note : 1813020

We can get the runtime dumps by the following-

1-  Log into the linux HANA host presenting the issue as sidadm user;

2-  Run command : 'hdbcons';

3-  On the hdbcons console run command below:

 > runtimedump dump

This will create a file under traces directory called 'indexserver....rtedump.trc'.

4-  Attach generated trace file to the OSS Message

Second Approach -

Additionally there is another way mentioned in the note to generate the runtime dumps from HANA Studio.For Example -

bsaxy002:HDB:sidadm xyz/usr/sap/SID/HDB02 1006> 'hdbcons';

SAP HANA DB Management Client Console (type '\?' to get help for client commands)

Try to open connection to server process 'hdbindexserver' on system 'ABC', instance '02'

SAP HANA DB Management Server Console (type 'help' to get help for server commands)

Executable: hdbindexserver (PID: 21629)

[OK]

--

> runtimedump dump

[OK]

--

> exit

[EXIT]

--

[BYE]

This command will generate the following :

indexserver_vadbsid.302553.rtedump.20140531-220023.021629.trc

indexserver_vadbsid.302553.rtedump.20140531-222723.021629.trc

indexserver_vadbsid.302553.rtedump.20140531-222929.021629.trc

indexserver_vadbsid.302553.rtedump.20140531-224633.021629.trc