Skip to Content
avatar image
Former Member

SAP Business One SQL vs HANA

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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):

    https://blogs.sap.com/2013/07/02/sap-business-one-on-sap-hana-solutions/

    Fabrizio

    Add comment
    10|10000 characters needed characters exceeded