SAP HANA Adminstration – Topics

SAP HANA Introduction

• SAP HANA – A short Introduction
• SAP HANA Information sources
• Revision strategy of SAP HANA

Preparing Installation

• Sizing of the SAP HANA
• Requirements

Installation

• Introduction SAP HANA Lifecycle Management Tools
• Advanced installation options
• SAP HANA Studio installation
• SHINE – SAP HANA Interactive Education
• Performing a Distributed System Installation

Post Installation

• Post-Installation Steps
• Updating SAP HANA

Architecture and Scenarios

• SAP HANA Memory Management and Data Persistence
• Software Packaging
• SAP HANA Roadmap and Scenarios
• Deployment Options

Admin Tools for SAP HANA

• SAP HANA studio for administrator
• DBA Cockpit
• HDBSQL command line tool

Operate SAP HANA

• Starting and stopping SAP HANA
• Configuring SAP HANA
• Periodic Manual  tasks
• Transporting changes

Backup and recovery

• Concepts of Backup and Recovery
• Data Area backup
• Log Area backup
• Additional backup topics
• Recovery & Database copy
• Backup and Recovery using storage snapshot

Monitoring and Troubleshooting

• Configuring Traces
• Working with Diagnosis Information and Diagnosis Files
• SQL Console & Query Analysis
• Remote Support

Maintaining Users and Authorizations

• User Management
• Types of Privileges
• Roles
• Administrative tasks
• Information Sources for Administrators
• SAP HANA Live Authorization Assistant

High Availability and Disaster

• High Availability
• SAP HANA Scale Out

Multitenant Database Containers

• Administration of Multitenant Database Containers
• Backup and Recovery of Multitenant Database Containers

Data Provisioning

• Configure data replication with SAP Landscape Transformation (SLT)

SAP BW HANA Migration

• SAP Certification Guidance

Delta Merge in SAP HANA

DELTA merge is an operation to move the data from WRITE optimized DELTAmemory to READ optimized and Compressed MAIN memory. This can be done automatically by HANAusing Smart Merge technology or manually using MERGE DETLA OF sql statement or using right click option on HANA studio.

The Delta Merge Operation is an operation on a table column store data structure.

The purpose of the delta merge operation is to move changes collected in the delta storage to the read-optimized main storage.

After the delta merge operation, the content of the main storage is persisted to disk and its compression recalculated and optimized if necessary.

A further result of the delta merge operation is truncation of the delta log (ie redo operations)

It is important to understand that even if a column store table is unloaded or partly loaded, the whole table is loaded into memory to perform the delta merge.


During the delta merge operation, every partition of a partitioned table is treated internally as a standalone table with its own data and delta store.