Skip to Content

A lot of customers asked me in the last weeks ‘what should be used HANA 1.0 or HANA 2.0?’. There are some reasons you can’t avoid to migrate to HANA 2.0, but there are still some aspects left resulting in staying at HANA 1.0.
There are tons of new features and improvements with HANA 2.0, but do you really need them?

The most common answer against HANA 2.0 is the complexity coming with MDC. For sure you have to review your concepts for running HANA systems regarding security/authorizations, backup&restore, parametrization and monitoring. SAP will improve such tasks and make the switch easier, but it is currently a challenge to adapt it.

When should and when I have to use HANA 2 or even it is not wise to upgrade?
The ‘should’ section is more like nice to have but may not really important for your business.
The ‘have to’ section includes aspects which you can’t avoid or influence if they come true.
The ‘should not’ section listing all characteristics pro HANA 1.0.
For sure the list is not complete and there are more aspects and I will adjust it if there are more important ones, but it only should give you a first overview and tendency.

You should use it when you…:

  1. want to benefit from new performance features like Dynamic result Cache, improved garbage collection / locking, optimized compression, HEX (HANA Execution Engine)
  2. want to use event triggered a log backups
  3. want to install license keys for individual tenant databases
  4. want to use Data Shipping Parallelization within HSR
  5. want to use redo log encryption (1642148)
  6. want to restore a single database backup directly into a tenant database (2096000)
  7. want to lower your TCO with persistent memory (pmem) / NVM / NVRAM (2618154)

You have to use it when…:

  1. it is planned to use S/4 HANA 1709 (2524661)
  2. it is planned to use HSR active / active (2391079)
  3. it is planned to use POWERPC SLES12 LE (little endianness)
  4. you want to use special functions/features in SDA / SDI / SDQ (more supported remote databases and functions/syntax)
  5. you want to migrate from INTEL to PowerPC or vice versa via restore/recovery (1642148)
  6. you want use Cross-SID-copy: Backint-based backups of a tenant database ca be recovered into a tenant database using a target SID or tenant NAME that is different to the original one (2096000)
  7. you want to use HANA Cockpit 2.0 (running only on HANA 2.0)
  8. it is planned to use secondary time travel feature with HSR (HANA 2.0 SPS03)
  9. it is planned to use multi-target replication (HANA 2.0 SPS03)

You should not use it when…:

  1. you are currently on old hardware: Haswell and older => recommended to buy new HW (2399995)
  2. you are using SLES11 SP4 BE (big endianness) with PowerPC and don’t want to migrate (till end of maintenance of SLES11 SP4)
  3. currently no feature used and not planned to use which only comes with HANA 2.0
  4. you want to avoid using MDC (default mode since HANA 2.0 SP01)
  5. you are using XSC (XS Classic) and not ready to use XSA (XS Advanced) – XSC is still supported but not recommended (2396214)
  6. you are using a deprecated feature (2425002)
  7. your current release / product is not supported on HANA 2.0
  8. you are affected by the limitation using cross tenant access (2196359 / 2312583)

Another question which also comes up is regarding stability. This depends on how do you use your database? Which features are used and how proper you followed the best practices (system setup / parameters) of your hardware and software vendors. Do you frequently review the known issues of your SPS? May be there are some workarounds to get your revision stable.

Note Description
2265103 SAP HANA DB: Known issues detected in SPS11
2325090 SAP HANA DB: Known issues detected in SPS12
2432112 SAP HANA DB: Known issues detected in Hana 2.0 SPS00
2462139 SAP HANA DB: Known issues detected in Hana 2.0 SPS01
2525424 SAP HANA DB: Known issues detected in Hana 2.0 SPS02
2628684 SAP HANA DB: Known issues detected in Hana 2.0 SPS03

For details what will be changed in each SPS check and the HANA Academy channel

To report this post you need to login first.


You must be Logged on to comment or reply to a post.

  1. Roland Kramer

    Hello Jens,

    nice Blog, as this question is raised everywhere in the last time …
    for additional limitations about the MDC usage forced with HANA 2.0 see also the following SAP Notes especially together with BW on/for HANA:

    Note 2096000 – SAP HANA multitenant database containers – Additional Information

    Note 2121768 – Considerations with SAP HANA multitenant database containers, SAP BW, and SAP BW/4HANA

    Note 2196359 – Limitations for cross-database access in an SAP HANA MDC environment

    Note 2312583 – FAQ: BW and HANA MDC: Cross-Database-Access in HANA Multitenant Database Containers

    Best Regards Roland

    1. Jens Gleichmann Post author

      Hi Roland,

      thanks for the follow up! I have added the MDC cross tenant access as limitation. Good additional aspect for the list.





Leave a Reply