SAP HANA is an in-memory database for performing real-time data analysis, and development of applications on the top of real-time data. HANA administration deals with managing SAP HANA system in a single and distributed system environment. Each HANA system can contain multi node architecture with each node containing multiple processors for fast speed data analysis and real-time data provisioning. You can use Smart data access to get the data from non-SAP systems without importing the data to HANA database, and virtual tables can be used to perform read/write data operations

SAP HANA Administration includes the following activities −

SAP HANA multiple host system management
SAP HANA Administration Tools
SAP HANA System Management and Availability
SAP HANA Lifecycle Management
SAP HANA Security and User Management
SAP HANA Backup and Recovery Management
SAP HANA Data Provisioning and Integration with non-SAP systems

Each SAP system contains multiple servers and it can be checked in HANA Studio under Administration tab. SAP HANA Studio contains Administration Perspective (default) to manage all admin tasks in HANA systems.

To check the landscape of HANA system, navigate to Landscape tab in HANA studio. Services shows all the services running on HANA system.

The following screenshot shows SAP HANA system and all the key services running under system Landscape for the same system.

You can see the service name corresponding to each server in HANA system landscape.

SAP 15 2

From the dropdown list, you can select all the host names and services that you want to see and the status of each system.

Various details available for each service includes: Start time, CPU and Memory details, Used Memory, Peak Used Memory, Effective Allocation Unit, Physical Memory on host, and SQL Port.

SAP 16 2

When you click the Hosts tab, you can see the host names in the System Landscape and the role of HANA system defined under Name server.

You can also check the status of the systems, failover status, Index server role, and Failover group.

SAP 17 1

SAP HANA Admin – Architecture Overview

In SAP HANA system architecture, it contains all the server components that gets installed at the time of installation. Each server has defined set of tasks and different services are run for each server in a SAP HANA distributed environment.

The most important server system and the heart of HANA system is the Index server. This server is responsible for processing SQL/MDX statement using engines in the Index server. It also contains Session and Transaction Manager to keep track of completed and running transactions.

Persistence Layer in the Index server is used for backing up data and transaction of log files.

SAP 18 1

Following table lists all the key server components in HANA, the corresponding services, and OS process details.

Server Component Name	Service Name in HANA system	OS Process Name	Component Details
Index Server	Indexserver	hdbindexserver	Responsible for processing SQL statements using SQL/MDX Processors.
Name Server	nameserver	hdbnameserver	To maintain topology of SAP HANA system. This is used to manage all the running components and data stored on each component.
XS Classic Server	xsengine	hdbxsengine	It can be used to develop and host applications on the top of SAP HANA system.
Data Provisioning Server	dpserver	hdbdpserver	To provide SAP HANA smart data access function.
Preprocessor	preprocessor	hdbpreprocessor	To analyze the text data and perform search capabilities.
Compile Server	Compileserver	hdbcompileserver	This is used to perform compilation of SQL Procedures and doesn’t contain any data.
Web Dispatcher	Webdispatcher	hdbwebdispacher	It is used to process HTTP/HTTPS request to HANA XS Engine.

SAP HANA Admin – Multitenant Database

It is possible to set up multiple databases into a single HANA system. When you install SAP HANA system in multiple container mode, you can setup multiple isolated databases in single SAP HANA system. This is called Multitenant database containers.

You can also covert a single container HANA system to multiple container databases HANA system. In multiple container HANA system, each database runs on the same infrastructure and uses the same computing resources. However, each database contains following components −

Database Users
Repository
Catalog
Backups
Traces and Logs
Persistence

All the database objects – tables, schemas, database views, SQL procedures – are separate for each database. You can also perform cross-database functions in multitenant database.

SAP 19

In SAP HANA system, it contains multiple server – Name Server, Index Server, Preprocessor, and XS Server. With multiple container databases, different combinations of the above servers are used.

Name server maintains the landscape details of the system and the system databases run the Name server. The Name server of multitenant databases doesn’t contain topology information and this information is stored in tenant database catalog.

Preprocessor and Compile server runs on system databases as they don’t contain persist data. Each tenant database contain its own index server and SAP HANA Classic Server runs on the Index server of tenant database by default.

You can see the architecture of SAP HANA multiple container system in the following screenshot. Each instance of system database runs on multiple hosts to provide scalability and system availability. In multiple worker configuration, when a system fails, standby instance will fail over all active databases.

In the above screenshot, you can see 2 databases distributed across three hosts in multiple container database system.

In multiple container architecture, the system database is set up at the time of installation of a multiple-container system or when you convert a single container system to multiple container system. This is used to manage information about the system as a whole, and also for tenant databases. It is used for Central System Administration in multitenant environment.

System database contains data and user data for system administration and SAP HANA Administration tools such as SAP HANA Studio to connect to the system database. All the administration tasks that are performed in the system database applies to the whole system and you can also target the configuration for a specific tenant database. System database contains complete landscape information about Tenant components, however it doesn’t contain topology related information.

SAP HANA Admin – Multiple Host Systems

When your SAP HANA system is installed on a single system, it is known as Single Host System; however, when you distribute the system installation on multiple systems, it is called Multiple Host Systems. Using multiple host systems, you can use features such as Load Balancing and Scale Out feature of SAP HANA system. You can overcome the hardware limitations by distributing the load of your system on multiple servers.

You can also assign different tables to different hosts using database partition to split a single table between hosts (partitioning of tables), and to replicate tables to multiple hosts.

When SAP HANA system is installed on multiple hosts, SAP HANA Administrator can perform start and stop, backup, or run update as a single system by taking single System ID known as SID.

Each SAP HANA system contains its own server components for each host and the request from the client application can be distributed to different hosts in multiple host systems.

SAP 20

In the above screenshot, you can see SAP HANA multiple host system architecture, where HANA system has 3 separate instances, and each instance has its own server components.

The request from the client application can be distributed to any of the instance in this environment.

So, this brings us to the end of blog. This Tecklearn ‘Overview of SAP HANA Administration’ blog helps you with commonly asked questions if you are looking out for a job in SAP Hana Administration and SAP Domain. If you wish to learn SAP Hana Administration and build a career in SAP domain, then check out our interactive, SAP HANA Administration Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

https://www.tecklearn.com/course/sap-hana-administraion/

SAP HANA Administration Training

About the Course

SAP HANA Administration training will help you learn SAP HANA administration tools, security and user management, system management and availability, data provisioning and integration with non-SAP systems and more. You will deploy SAP HANA Studio, automate through OS scripts, command line admin tools through hands-on projects and case studies. This course is designed to clear the HA200 SAP HANA Operations and Administration Certification conducted by SAP and helps you get the best jobs in top MNCs.

Why Should you take SAP HANA Administration Training?

The average salary for SAP HANA Database Administrator ranges from approximately $65,843 yearly for Administrator to $143,051 yearly for Enterprise Architect. – Indeed.com
SAP HANA is one of the top tools for working with real-time data due to the transformational nature of this tool. The role of an SAP HANA Administration and Operations personnel is critical of the success of SAP HANA deployment in any industrial set-up.
Worldwide Business Intelligence and Analytics Market to grow to $22.8 billion in next 2 years – Gartner.

What you will Learn in this Course?

Overview of SAP HANA

Overview of SAP HANA
Features and Benefits of SAP HANA
SAP HANA Components
Concept of SAP HANA guides
Scenarios in SAP HANA Administration

Architecture of SAP HANA

What is SAP HANA persistence?
Concept of Sizing in SAP HANA
Process of achieving scale out in SAP HANA
How SAP HANA achieves in-memory computation
Concept of columnar database
How SAP HANA is so fast with comparison to other tools

SAP HANA installation

Overview of SAP HANA tools

SAPA HANA Studio for Administration activities in SAP HANA
Accessing local and remote HANA systems using Client Tool
Monitor, Control, Configure and Administer the SAP HANA database using DBA Cockpit
Using HANA Studio Information modelling and data provisioning in HANA database
SAP HANA Transport

SAP HANA Operations

Privileges in HANA
Configure Password Policy and create user in SAP HANA
Auditing in SAP HANA

SAP HANA Smart Data Access

Data Provisioning in SAP HANA

Leveraging SAP HANA technology and integration architecture for enriching, cleansing and transforming data from disparate sources
Data replication with the SAP Landscape Transformation (SLT)
Implementing SLT Configuration with SUSPEND LOAD

SAP HANA Operations

Create Repository and Job Server
SAP GRC Architecture

Administration Operations in HANA Studio

Updating HANA database using lifecycle management
Security in SAP HANA
Sessions and Transactions in SAP HANA
Configure System Replication using HANA Cockpit

Migration to SAP HANA using DMO

Performance Monitoring and Analysis in SAP HANA

Got a question for us? Please mention it in the comments section and we will get back to you.

563