Skip to Content
0

Memory utilisation

Oct 24, 2016 at 08:55 PM

142

avatar image
Former Member

Hi team,

I have a question regarding OOM.

We had an issue where the HANA database went OOM. Now i wanted to give RCA.

In order to perform the same i started with the below sql.

HANA_Memory_TopConsumers_History_Rev90+_ESS

But it is not giving much information as to what might be the cause.

How do i start my investigation?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

6 Answers

avatar image
Former Member Nov 01, 2016 at 04:09 PM
0

Folks any clues regarding the same?

Share
10 |10000 characters needed characters left characters exceeded
Lars Breddemann
Nov 03, 2016 at 10:15 AM
0

How about checking the oom dump file?

Share
10 |10000 characters needed characters left characters exceeded
Lars Breddemann
Nov 03, 2016 at 10:16 AM
0

How about checking the oom dump file?

Share
10 |10000 characters needed characters left characters exceeded
Yuksel AKCINAR Nov 03, 2016 at 02:05 PM
0
Share
10 |10000 characters needed characters left characters exceeded
Yuksel AKCINAR Nov 03, 2016 at 02:07 PM
0

Hello,

.

When I was investigating OOM issue before I found below notes and links.

These could help you too.

Check the swap value of the system also. (Given 2047 MB according to a note for swap)

1999997 - FAQ: SAP HANA Memory

1984422 - SAP HANA: Analysis of Out-of-memory (OOM) Dumps

http://scn.sap.com/community/hana-in-memory/blog/2014/01/05/6-tips-to-avoid-hana-out-of-memory-oom-errors

http://scn.sap.com/community/hana-in-memory/blog/2013/12/29/6-golden-rules-for-new-sap-hana-developers

.

Regards,

Yuksel AKCINAR

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 15, 2016 at 05:00 PM
0

Lars as you know, OOM gives the sql which failed during that point of time.

But its not the cause right which caused the issue right?

Its only a symptom due to lack of memory availbility.

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Last time I checked the OOM also provides an overview of the total memory usage.

In there you can find the elements that use most memory and that's what you would be looking for when looking for the cause, right?

0

Last time I checked the OOM also provides an overview of the total memory usage.

In there you can find the elements that use most memory and that's what you would be looking for when looking for the cause, right?

0