Skip to Content

Multitenancy in HANA

Nov 09, 2016 at 04:04 PM


avatar image
Former Member


I want to setup my Dev , QA and Prod servers on a single HANA box with Multi- tenancy.

What would be the impact on QA refresh cycles and is there a different way to do that with Multi-tenancy.


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

1 Answer

avatar image
Former Member
Apr 14, 2017 at 08:59 PM

Hello Ian,

Multi-tenancy is a great feature and is going to become standard and the only operation mode with SAP HANA 2.0 SPS01. Technically it is possible to setup Production, Quality and Development on a single HANA Box using Multi Tenancy. Each tenant database in an MDC system is self-contained and fully isolated. Each tenant has its own Database Catalog, Persistence, Backups etc which means a tenant db can be backed up and recovered independently from any other tenant. It is also possible to restore one tenant over another.

However in a Multi Container system, one should carefully consider the following if it includes production and non-production systems :-

- All the databases share the same installation of database OS, HANA DB software, and same computing resources. Any changes to the Binaries will impact all the environments if they are installed on the same Box using Multitenancy.

On-premise Deployment Using SAP HANA Tenant Databases

- In the the event of a DR (Disaster Recovery) scenario for the HANA Appliance or Box, all the instances, including production, will be impacted,

- In the event of a System Maintenance, all the instances including production will be impacted/down.

- 3rd Party Backup tools or Storage snapshot support for Tenant Database

SAP HANA multitenant database containers - Additional Information -

FAQ: SAP HANA Multitenant Database Containers (MDC) -

10 |10000 characters needed characters left characters exceeded