SAP Database Administration Deep Dive - HA200

Explore SAP HANA in-memory database basics, its advantages over traditional databases, relational structures, and how SAP HANA enables OLTP and OLAP for robust applications.

Discover how SAP HANA merges transactions and analytics in memory, using column and row stores, with data modeling and virtualization, plus lifecycle management and high availability.

Explore the core SAP HANA architecture, including name server, index server, compiled server, and preprocessor server, plus system and tenant databases and OLAP/OLTP capabilities.

Size SAP HANA using memory, CPU, and disk KPIs, then install the database with SAP HANA lifecycle management, aided by quick size and DB scripts.

Execute a SAP HANA database upgrade by backing up, locking users, stopping services, breaking replication, uninstalling SAP HANA client and AFL, then installing the DB version with client and AFL.

Learn SAP HANA administration tools, including web-based cockpit and eclipse-based studio, plus HTTP SQL, HTTP NCM, and HTTP LCM for installation, monitoring, and lifecycle management.

Explore how SAP HANA cockpit centralizes administration and performance monitoring, including workload management, sql plan hints, and capture and replay of the workload, plus deployment options.

Master SAP HANA cockpit administration tasks, including monitoring, alerting, backup and recovery, and system properties, plus cockpit manager operations for tenant DBs and resources.

Learn how to debug and optimize SAP HANA performance using cockpit and performance monitor, focusing on threats, sessions, transactions, SQL plans, and workload analysis to identify bottlenecks and tune resources.

Learn SAP HANA performance tuning and troubleshooting to identify root causes and prevent downtime. Use HANA cockpit and HANA studio, traces, alerts to diagnose log, memory, deadlock, and network problems.

Explore SAP HANA backup and recovery, including full, delta, incremental, and differential backups, save points, and log backups, using SAP HANA cockpit and Hana Studio.

Patch and upgrade SAP HANA using revision upgrades with HANA studio and LCM, including download from the SAP support portal, SAPCAR extraction, backups, and server-specific updates.

Configure SAP HANA replication to ensure high availability and disaster recovery by syncing data between primary and secondary systems and securing backups, trust, and SSL.

Discover SAP HANA data tiering using the native storage extension, separating hot data in memory, and warm and cold data stored on disk to optimize memory and cost.

Explore SAP HANA smart data integration, smart data access, and smart data quality (SDI, SDA, SDQ), using data provisioning service adapters to ingest, cleanse, and report from diverse sources.

Learn how SAP HANA table partitioning improves performance and manageability by splitting large column store tables into partitions, covering hash, round robin, range, and multilevel options.

Explore SAP HANA license keys, including temporary 90‑day licenses and permanent keys, and learn to install and renew them using the SAP support portal, cockpit, or studio.

Learn how to create SAP HANA users, assign roles and privileges, and manage user groups using HANA Studio or HANA cockpit for secure database access.