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.

[Former Member]

Are you getting some out of memory dumps? Without these it's impossible to know whats going on. More details needed.

[mrwong05]

Ill try to get some dumps.