Tenant Database in SAP HANA

Hi All,

SAP HANA supports multiple isolated databases in a single SAP HANA system. These are called tenant databases.

An HANA system is capable of containing more than one tenant database.

SAP HANA system will have one system database for central system administration and any number of tenant database.

SAP HANA system will be identified by a single SID & databases are identified by SID & Database name. All the databases share the same installation of database system software, the same computing resources, and the same system administration. But, each tenant database has self-contained and fully isolated with its own

• Set of database users
• Database catalog
• Repository
• Persistence
• Backups
• Traces and logs

 An SAP HANA database consists of multiple servers, for example, name server, index server, preprocessor server, and so on. The databases in an SAP HANA system run different combinations of these servers.

Tenant databases require only an own index server. Servers that do not persist data, such as the compile server and the preprocessor server, run on the system database and serve all databases.

  

 System Versus Tenant Database Administration

Tenant database systems have two levels of administration.

Some administration tasks are performed in the system database and apply globally to the system and all its databases. They include for example:

     · Starting and stopping the whole system

· Monitoring the system

· Configuring parameters in configuration (*ini) files at system level

· Setting up and configuring tenant databases

· Creating and dropping tenant databases

· Disabling features on tenant databases

· Configuring system- and database-specific parameters in configuration (*ini) files

· Backing up tenant databases

· Recovering tenant databases

·      

Some administration tasks are performed in the Tenant database and apply only to that database. They include for example:

     · Monitoring the database

· Provisioning database users

· Creating and deleting schema's, tables, and indexes in the database

· Backing up the database

· Configuring database-specific parameters in configuration (*ini) files

Thanks for reading, Please share your valuable feedback.   

Share this

Basis Genie