SAP HANA 2.0 Installation and Administration A Practical Guide

Part of:

Rajarajeswari Kaliyaperumal

Language

English

Pages

340

Level

Beginner

ISBN

9783960124436

ISBN Print

9783960124429

E-Books

or access all content

Flat rate

$19 per month

Single license
1000+ eBooks and video tutorials
Instant access
12 months($228per year)
Automatic renewal

More options

Already have an account? Sign in here!

More Details

Are you thinking of becoming an SAP HANA Administrator with strong foundational knowledge? Would you like to learn the basics or get your basics right? Then look no further. This expertly written guide walks readers through the fundamentals required to perform day-to-day operations, database sizing, installation, upgrades, and restore and recover activities as a HANA database administrator. Take a closer look at the architecture of the HANA database and explore the various deployment options. Learn how to install and upgrade HANA databases. Discover the tools available for administration and monitoring activities, including HANA Studio, HANA command line and the HANA Cockpit. Learn about essential database administration tasks such as system views, monitoring, and table partitioning. Examine security considerations and walk step by step through different types of backup and restore processes, including handling of encrypted backups, HANA System Replication and tenant copy. Learn how to efficiently troubleshoot HANA database issues, with expert guidance and practical advice.

HANA database architecture and deployment options
Installation and upgrade steps
Administration and monitoring tools
Backup and restore processes

Reading Example

2.1 Available deployment mode and types

2.1.1 Choosing a HANA database deployment

There are two models for installing HANA:

Appliance model—only certified hardware partners can install HANA components on validated hardware on a specific operating system.
SAP HANA Tailored Datacenter Integration (TDI)—certified administrators or official SAP HANA hardware partners can install HANA on approved hardware (from the hardware directory).

Once the deployment model has been selected, one of the technical deployment options, such as SCOS, MCOD, or MCOS, can be chosen.

These options can be deployed as a single tenant (scale-up) or multi-tenant (scale-out) setup across one or more hosts.

The chosen underlying server for the HANA database can be a physical server, an IaaS, or a virtualized environment.

Sample HANA deployment options

The HANA database can be installed on a single host with a single tenant in an SCOS model, either as an appliance-type deployment or as an SAP HANA TDI deployment.
The HANA database can be installed on multiple hosts with multiple tenants in an MCOS model, either as an appliance-type deployment or as an SAP HANA TDI deployment. This model of deployment is only supported for the production database, with certain restrictions. For more information, refer to SAP Note 1681092—“Multiple SAP HANA databases on one appliance”.

2.1.2 Understanding multi-container HANA database mode

The HANA database offers two deployment modes—single container mode and multiple container mode. In other words, SCOS, MCOS, MCOD and similar configurations can only be assigned to one of these two modes on a single host or on multiple hosts.

From HANA 1.0, and all versions prior to HANA 2.0 SP01, the default database mode was single container. However, as of HANA 2.0 SPS01, all the technical deployments mentioned in the previous sections can only be installed in multiple container mode (the default mode), also known as the tenant database mode.

Multiple container mode enables the HANA SID to accommodate more than one tenant database under the control of a SystemDB. Moreover, it does not always necessitate the existence of more than one tenant database. Note that the presence of a SystemDB within a HANA SID inherently implies this mode. As shown in Figure 2.1, multiple container mode always has a SystemDB component, whereas single container mode does not.

HANA Admin

Figure 2.1: Multiple container and single container mode

The benefits of multiple container mode include simplification and reduced capital expenditure on hardware. When a company requires additional HANA databases, this mode enables them to host new SIDs as isolated tenant databases on the same hardware, using the same database installation software and sharing some server components (RAM, CPU, etc.).

Conversely, in single container mode, any additional SIDs must be installed with their own database software and server components on the same or different hardware, without reusing components from existing HANA installations.

MDC mode

All subsequent topics discussed in this book are limited to the HANA multiple container database (MDC) mode.

Authors

Rajarajeswari Kaliyaperumal More about the author

Ratings

V. Pandi
30.07.2025
This book offers an in-depth and well-structured summary of all the important topics in SAP HANA, making it a valuable resource for both beginners and experienced professionals. The author has done an excellent job of breaking down complex concepts into digestible explanations, with a logical flow that supports progressive learning. One of the standout features of the book is its use of real-time screenshots, which significantly enhance understanding. By walking the reader through step-by-step visual examples, the book bridges the gap between theory and hands-on application. This is especially helpful for those who are new to SAP HANA or looking to sharpen their practical skills. The content covers a wide range of essential areas including HANA architecture, modeling, data provisioning, SQL scripting, performance optimization, and integration with SAP tools. Each chapter is rich in detail and thoughtfully organized, often including tips and best practices that reflect real-world scenarios. Whether you're preparing for certification, working on an implementation project, or simply expanding your SAP skill set, this book serves as a practical guide and reference manual.

Frequentlyasked questions

General questions and answers about our learning content.

Who is the learning content suitable for?

The learning content is designed for anyone who wants to gain SAP knowledge in a simple, compact, and practical way. Our learning platform offers content for beginners, advanced learners, and experts. This enables you to expand your knowledge step by step and continuously develop your skills toward becoming an SAP expert.

What makes the learning content special?

Our products—whether books, videos, or online training—deliver SAP knowledge concisely and practically, so you can apply it directly in your daily work, even if you have limited time. You benefit from a broad coverage of relevant SAP topics, high-quality content in four languages, and learning formats designed to fit your individual needs. This ensures that you can stay up to date and continuously develop your expertise.

What distinguishes our books from those of other providers?

Our books are characterized by a clear practical focus and a compact, easy-to-understand presentation. We explain complex SAP topics concisely—without unnecessary marketing buzzwords—so readers can quickly grasp the essentials and apply the new knowledge directly.

Can the product be exchanged?

Our print books can be returned within 14 days, in original condition. Return shipping is at your own cost.

How can I order a book outside of Germany?

We currently only ship books directly within Germany. If you are ordering from outside Germany, we recommend purchasing via Amazon. You can find the link by selecting “Buy eBook” on any product in our webshop and Amazon will then show you both the eBook and print versions available for purchase.

Alternatively, you can access all our content with a digital subscription, starting at $19 per month.

Who can I contact if I have questions?

Our team is always happy to help and will respond to your questions as quickly as possible (usually within 1–2 days). You can also contact us if you have questions for one of the authors. Email: contact@espresso-tutorials.com