Memory Allocation Failed, column store error, search table error

[mrwong05]

Hi,

For Hana 2.0 SPS02 rev 23 256 GB license. Lumria Server 1.31 Add-on BI platform 4.2 SPS 05.

I am getting what seems like very High Memory usage on my Hana Server. Can someone please tell me how to debug and optimize ? I did a HDB stop/start as well as machine reboot. My large join queries in Lumira are failing due to HDB i believe.

Thanks for your insight,

Matt

[lbreddemann]

A great starting point for such questions are the HANA documentation and the SAP notes around memory management.

I highly recommend to get a grip on the concepts of SAP HANA first as any analysis will build on these.

[candy_zhan]

Hi Matt,

There is a guide answer might provide you with some ideas.

https://ga.support.sap.com/dtp/viewer/#/tree/2/actions/303

Also note 1999997 helps, which covers most of OOM situation.

To detailed analyze this issue, you can create an incident to HAN-DB, as planViz and traces are needed for deep analysis.

Best regards,

Candy

[mrwong05]

Thanks Candy, This is still an issue for me and will be fore the foreseeable future. I need a better understanding of the HANA engine, memory requirements, and query limitations.