SAP HANA 2.0 SPS 04–07+Production Engineering Reference3–5 Year Senior DBA Target

SAP HANA DBA Keybook

A complete, production-grade technical knowledge platform, dynamic SQL handbook, forensic troubleshooting guide, and advanced interview preparation resource for SAP HANA Database Administrators.

Operational Core Portals

M_* Tables & Architecture Diagram
Complete catalog of dynamic monitoring views (SYS.M_*): architectural definitions, operational uses, key columns, and full engine wireframe diagram.
M_SERVICE_MEMORY • M_BLOCKED_TRANSACTIONS • Diagram
SQL Handbook (M_* Views)
Production-tested queries for service memory, CPU, thread saturation, lock contention, savepoint blocking, and HSR.
M_SERVICE_MEMORY • M_EXPENSIVE_STATEMENTS
P1 Incident Runbooks
Step-by-step Standard Operating Procedures for /hana/log 100% full, Out-of-Memory dumps, and startup crash loops.
Interactive Checklist • Decision Trees
Senior DBA Interview Bank
Targeted question bank for 3–5 year roles, strategic answer phrasing, follow-up traps, flashcards, and mock quizzes.
Flashcards • Scenario Q&A • Scoring
HDBinfo vs. HDB info
Disambiguating Linux process monitoring from fullsysteminfo.py trace and diagnostic dump extraction.
fullsysteminfo.py • ps parser
Architecture Diagrams
Interactive Mermaid diagrams mapping engine memory, persistence loops, MDC isolation, and HSR topologies.
Mermaid.js • Copy Source • Flowcharts
Personal Notes & Checklist
Track your learning progress, completed topics, bookmarked reference queries, and custom lab notes.
Local Storage • Zero Login • Private

Daily Morning DBA Operational Checklist

Battle-tested 5-point routine executed daily at 08:00 AM before peak business transaction traffic.

01Database & Service Health Check

Verify instance status via HDB info and sapcontrol -nr <NR> -function GetProcessList. Confirm nameserver, indexserver, compileserver, and preprocessor are GREEN.

HDB info / sapcontrol
02Backup Verification & Catalog Integrity

Inspect SYS.M_BACKUP_CATALOG. Confirm that overnight full/differential data backups and continuous automated log backups (every 15 min) completed successfully.

M_BACKUP_CATALOG
03Memory & Resource Consumption (GAL)

Query SYS.M_SERVICE_MEMORY. Verify Global Allocation Limit (GAL) vs. Resident Memory and Used Memory. Ensure no tenant approaches 90% allocation or OOM.

M_SERVICE_MEMORY
04Alert & Trace Log Inspection

Review _SYS_STATISTICS.STATISTICS_CURRENT_ALERTS and inspect alert_<SID>.trc, nameserver.trc, and indexserver.trc for warnings, blocked locks, or slow SQL.

_SYS_STATISTICS / alert.trc
05HSR Replication & Storage Capacity

Execute hdbnsutil -sr_state to ensure secondary site is ACTIVE in syncmem mode with logreplay. Check df -h across /hana/data, /hana/log, and /hana/shared.

hdbnsutil -sr_state / df -h

Complete SAP HANA DBA Curriculum (20 Modules)

Structured modular roadmap covering every requirement for enterprise production engineering and certification.

Mod 01:SAP HANA Fundamentals

In-memory paradigm, column/row stores, compression, Scale-Up vs Scale-Out hardware.

Fundamentals
Mod 02:SAP HANA Architecture

Process hierarchy, hdbdaemon, nameserver, indexserver, MDC SystemDB & Tenant isolation.

Architecture
Mod 03:Internal Working & Persistence

Delta merge mechanics, write-ahead logging (WAL), savepoints, crash recovery.

Internals
Mod 04:Installation & Configuration

HDBLCM lifecycle manager, SLES/RHEL prerequisites, swap configuration, Rocky Linux lab setup.

Installation
Mod 05:Linux, Filesystem & Ports

Filesystem mounts (/hana/shared, /hana/data, /hana/log), port formulas, HDB CLI tools.

Linux & OS
Mod 06:Database Administration

Configuration layers (DEFAULT to HOST), .ini parameter hierarchy, dynamic reconfiguration.

Administration
Mod 07:SQL Handbook

Production-ready SQL queries for services, memory, CPU, locks, backups, and HSR.

SQL Handbook
Mod 08:HDBinfo & Diagnostics

HDBinfo vs. HDB info disambiguation, fullsysteminfo.py collection, trace & crash dump analysis.

HDBinfo & Diagnostics
Mod 09:Monitoring & Alerts

SAP HANA Cockpit 2.0, Embedded Statistics Service (ESS), _SYS_STATISTICS alerts.

Monitoring
Mod 10:Backup & Recovery

Full/differential backups, log archiving, backup catalog retention, Point-in-Time Recovery (PITR).

Backup & Recovery
Mod 11:HSR & High Availability

HANA System Replication modes (sync/syncmem/async), logreplay, planned takeover, failback.

HSR & High Availability
Mod 12:Performance Tuning

Expensive statement tracing, Plan Visualizer (PlanViz), OOM dumps, lock contention triage.

Performance Tuning
Mod 13:Security & User Governance

Standard vs. restricted users, catalog vs. HDI roles, SSFS encryption keys, hdbuserstore.

Security
Mod 14:Upgrades & Lifecycle Management

SPS and revision patching via HDBLCM, pre-upgrade backups, SAP Host Agent maintenance.

Upgrades
Mod 15:Production DBA Runbooks

Emergency P1 runbooks: /hana/log 100% full, Out-of-Memory dumps, indexserver crash-restart loop.

Production Runbooks
Mod 16:SAP Basis Integration

Application connectivity, homogeneous system refreshes (PRD to QAS), BDLS, SUM DMO.

SAP Basis Integration
Mod 17:Troubleshooting Labs

Hands-on forensic case studies: post-crash indexserver startup, OOM root cause, Rocky Linux setup.

Troubleshooting Labs
Mod 18:Interview Preparation

Searchable 3-5 year SAP HANA DBA question bank, strategic interview answers, quizzes, flashcards.

Interview Preparation
Mod 19:Quick Reference

DBA cheat sheets, SAP Basis T-codes, dynamic views (M_*), port matrix, Linux commands.

Quick Reference
Mod 20:Architecture Diagrams

Interactive visual architecture gallery rendered with Mermaid diagrams.

Architecture Diagrams