SAP HANA CPU spike to 100%

[kalakalauday]

Hi,

I am working on SAP HANA 1.0 SP12 i have Developed a CDS with multiple table joins and also some calculated coloumns with case and division function,while i am executing this view 100% of cpu is consumed and get down once the cds is executed.

[HakanHaslaman]

Tracing a very high CPU Situation at the time it happens, you need to collect multiple sets of runtime dumps (https://launchpad.support.sap.com/#/notes/1813020).

During the high CPU phase please also collect Kernel Profiler Traces (https://launchpad.support.sap.com/#/notes/1875973 and https://launchpad.support.sap.com/#/notes/1804811).

For afterwards analyzing the High CPU usage, you need to check the Thread Samples (https://launchpad.support.sap.com/#/notes/2114710).

If you need assistance to analyzing this files, please open a support incident and provide the files to the product support, which can analyze it for you.