SAP HANA Administration

Richard joined SAP's Active Global Support in 2008 and moved to the SAP HANA Customer Solution Adoption team in 2010, focusing especially on DBA topics and data modeling. Since the beginning of 2013, he has led the SAP HANA program within CSA, which consists of about 20 product experts from around the world. Lars Breddemann has been working with database management systems since 1998 as a developer, DBA, supporter, and systems architect. Having worked in SAP AGS product support since 2003, he has experience with multiple database technologies (Oracle, SAP MaxDB/liveCache), SAP Business Warehouse, and, since 2010, SAP HANA. In 2011, he moved to the Customer Solution Adoption (CSA) team, where he assumed the role of SAP HANA expert. Specializing in core database technology, development, supportability, and performance analysis, Lars educated hundreds of users, partners, and colleagues and has been called into projects around the globe as the go-to authority. Lars is an acclaimed SAP TechEd speaker, a leading SCN contributor and moderator, and was appointed as one of the first SAP HANA Distinguished Engineers in 2012.

Preface
Architecture of the SAP HANA Database
The Basics
The Physical View: SAP HANA Servers
The Operating System View: Database Processes
The Logical View: Internal Architecture of the Database
Distributed SAP HANA Systems
The Appliance Concept of SAP HANA
Release Cycles of SAP HANA Database Software
Summary
SAP HANA Scenarios: Administration Considerations
SAP HANA as a Database in Application Servers
SAP HANA as a Development Platform
Mixed Scenarios
Summary
Installation and Updates
Preparing for Installation and Updates
Tools for Installing and Updating SAP HANA Systems
Installing an SAP HANA Database
Updating an SAP HANA Database
Installing Multiple Instances of an SAP HANA Database on the Same Physical Server (Nonproduction)
Installation and Update in Batch Mode
Installing and Updating Scale-Out Systems
Troubleshooting
Summary
Administration Tools
Introduction to SAP HANA Studio
Database Administration with SAP HANA Studio
Monitoring the Database with SAP HANA Studio
DBA Cockpit for SAP HANA
Summary
The Persistence Layer
Log and Data Volumes: The Data Image on Disk
Log Backup
Snapshots
Data Backup and Recovery of the SAP HANA Database
Disaster Recovery Setups and System Replication
Summary
Scale-Out Systems and High Availability
Scaling Out SAP HANA Systems
High Availability with Host Autofailover
Client Connect in Distributed Systems
Summary
Objects
Common Properties of Database Objects
Tables
Triggers and Constraints
SQL Views
Column Views
Sequences
Procedures and Functions
Synonyms
Summary
Table Types
Common Properties of All Tables
Row Store Tables
Column Store Tables
Special Types of Tables
Summary
Working with Tables
Loading Tables to and from Memory
Running Delta Merges
Partitioning and Distributing Tables
Optimizing Table Distribution and Partitioning
Importing and Exporting Tables
Checking Tables for Consistency
Summary
Sessions and Transactions
Introduction to Sessions and Transactions
Processes and Threads
Monitoring Sessions and Transactions
Concurrency and Parallelism
Summary
Working with the Repository
Properties of the SAP HANA Repository
Creating and Editing Objects in SAP HANA Studio
Deleting Development Objects in SAP HANA Studio
Mechanisms for Exporting and Importing Objects
Change Recording and Transports
Summary
User Management and Security
Essential Security-Related Concepts
Database Users
Authentication Methods
Securing SAP HANA's Network Interfaces
Auditing in the Database
Summary
Roles and Privileges
Database Roles
Privileges in the Database Catalog and Repository
Types of Privileges in SAP HANA
Critical Privileges and Privilege Combinations
Standard Roles for SAP HANA Systems
Troubleshooting Authorization Issues
Summary
Planning and Setting Up an SAP HANA System Landscape
Preparation: Sizing, Hardware Choices, and More
Planning the System Landscape
Bootstrapping the System
Summary
Tools for Performance Analysis
Load Diagram
Alerts Tab
Expensive Statements Trace
EXPLAIN PLAN
PlanViz
Further Resources
Summary
Monitoring and Root-Cause Analysis
Monitoring
Error Messages
Diagnostic Files
Server Side Traces
Client-Side Traces
Summary
The Authors
Index