Skip to Content

SAP Business One SQL vs HANA

Oct 20, 2017 at 05:57 AM


avatar image
Former Member

Quick questions here:

What is the recommended RAM for HANA?

As I understand the database for HANA is being stored at RAM. Supposed the server has RAM of 128GB, does it mean the database is limited to the size of 128GB only?

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

1 Answer

Fabrizio Zenklusen Oct 23, 2017 at 08:54 AM

Hi Jim,

I'm not a HANA expert, maybe someone else can precise my thoughts:

- Recommended RAM for B1 on HANA is 64 GB (at least)

- Yes, the database tables will be stored in RAM at runtime. So in your case it will be limited to 128 GB. SAP suggests: "The available RAM space of SAP HANA server hardware must at least be greater than the expected growth of the customer database in 3 years".

The following blog post by SAP could be helpful, especially the B1H sizing tool (topic #1 - documents):


10 |10000 characters needed characters left characters exceeded