SAP B1 HANA memory issue

[anandrd]

Hello Experts,

We are running on SAP B1 ON HANA With 10.0 Version FP 2111. (Not B1 for Cloud)

We have 10 Users of SAP B1 (2 Prof + 8 Lim Logistics) & we use one block Hana Engine license to use SAP B1 HANA.

We face SLD issue frequently & our cloud partner informs us that HANA ran out of memory so it is the reason for SLD Service failure.

However after restart of services it resumes to function as normal & we will not face any issue for a month(approx) again same happens, Since this happens cyclic, we would like to understand what is the actual root cause.

As from cloud provider we have the root cause as HANA memory is low and need to increase memory to 2 blocks 128 Gb of memory.

We would like to calculate, estimate how much of memory is required for our database

• We tried calculating based on three ways using below query we got 1.25 GB

with CST AS (
select SCHEMA_NAME,SUM(MEMORY_SIZE_IN_TOTAL/1024/1024/1024) as memGB
from M_CS_TABLES
group by SCHEMA_NAME)
select * from CST

order by memGB desc

• After Backup of HANA database Uncompressed Size (1.12 GB)
• After Backup of HANA database Compressed Size (511 MB)

Our calculation was very basic, 1.25 GB* 20 times of size = 25 GB

(10x for Size + 10x for operation capacity)

But still we have not reached 64 GB of HANA memory. Can HANA experts provide us the correct guidance pls on extending our HANA memory Block?

Thank you in advance

Best Regards

Anand Ramachandran

SAP HANA  SAP Business One SAP HANA Cloud 

@Laszlo @simon25 @Laszlo_Thoma @Cocquerel @PierreBrothier @pfefferf 

[Laszlo_Thoma]

Hi Anand Ramachandran,

Issue description: "...the root cause as HANA memory is low..."
"However after restart of services it resumes to function as normal & we will not face any issue for a month(approx) again same happens,"

Issue:
Memory problem that (regularly) occurs after restarting the service, approx. after a month. So SAP HANA uses more and more memory over time until reach the limit.

I recommend you the following documents to analyze the issue:

1. Collected information about memory in context of SAP HANA
2. SAP GUI - Transaction Code - DBACOCKPIT (Load History) 
3. 3284834 - SQL Statement Collection: "HANA_Configuration_Minichecks" report for SAP HANA
4. 3456746 - SQL Statement Collection: "HANA_Memory_OutOfMemoryEvents" report for SAP HANA
5. 3330262 - SQL Statement Collection: "HANA_Memory_Overview" report for SAP HANA

Regards,
Laszlo