SAP HANA Administration

Explain SAP HANA sizing using memory sizing and QuickSizer, covering data and log volumes, backups, and compression, with appliance and TDI deployment for on premise or cloud.

Analyze operating system requirements for SAP HANA, focusing on Linux platforms, SUSE and Red Hat, and the notes and installation guides to plan single or multi-host deployments with shared storage.

Explore HDBLCM and HDBALM to install, update, and maintain HANA environments using command line, GUI, and web interfaces.

Learn advanced SAP HANA installation using batch mode and command line parameters with HDBLCM, including configuration files for silent installs and default paths and passwords.

Set up a distributed SAP HANA landscape with a master node, slave or worker nodes, and a standby node, sharing a single SID and storage (/hana/shared, /hana/data, /hana/log) via hdblcm/hdblcmgui.

Install a SAP HANA system on a SUSE Linux host, using HANA 2 SPS3 (SPS4 available), with 32 GB memory and data and log volumes, managed by HDBLCM and cockpit.

Explore the SAP HANA architecture, including system and tenant databases, multi container MDC, name server, and web dispatcher, plus single to multi container migration and tenant isolation.

Explore SAP HANA memory management, covering RAM usage, data and log volumes, and the persistence layer, plus delta merge and preload strategies for fast startup.

Explore SAP HANA cockpit 2.0, a web-based central tool to monitor and manage multiple HANA databases, run SQL queries, and perform admin tasks from a single interface.

Install SAP HANA cockpit by meeting hardware and OS requirements, installing HANA database, using HDBLCM to configure cockpit, creating cockpit_admin with a master password, and verifying URLs via xs login.

Configure SAP HANA cockpit to manage databases, create resource groups and cockpit users, and assign permissions using guided procedures, technical users, and default cockpit admin.

Update SAP HANA cockpit to receive security updates and new functionalities, upgrading all cockpit components with the SAP system using HDBLCM, and perform full backups.

Explore SAP HANA scenarios and roadmaps, including sidecar and primary persistence, platform edition, agile and operational data marts, data replication, greenfield vs brownfield, and DMA to DMO migrations.

Identify and compare SAP HANA deployment options, including appliance, TDI, and certified hardware, then explore on premise, hybrid, and cloud configurations with MDC and other deployment models.

Learn the essential post-installation steps for SAP HANA, including connecting to Solution Manager, enabling SAP support and remote access, performing backups with milestones, adjusting configuration parameters, and applying permanent licenses.

Upgrade SAP HANA with version, patch, and revision upgrade scenarios using HDBLCM. Manage uptime, downtime, prerequisites, backups, and licensing.

Manage SAP HANA deployments with the resident HDBLCM tool, adding or removing hosts and roles via command line, GUI, or web, for scale-out configurations and interservice communication.

Explore SAP HANA interactive education (SHINE), a demo sandbox of core HANA features from HDB association to UI integration and rules, with setup via download center.

Understand the SAP HANA revision strategy, including revision terminology and maintenance revisions, and how SPS 00–02 bundles core revisions with non-core support packs.

Discover SAP HANA administration tools, including SAP HANA cockpit and studio, SQL HDBSQL, Solution Manager, SAP DBA cockpit, and SAP Landscape Management for administration, monitoring, and automation across systems.

Master hdbsql, the SAP HANA command line tool, to run SQL, procedures, and catalog queries in interactive or non-interactive modes. Learn login methods and how to use hdbuserstore for credentials.

Explore the SAP HANA DBA cockpit, a platform-independent tool to monitor SAP HANA databases and ABAP environment, manage alerts, backups, and landscape connections from a single cockpit.

Explore SAP HANA Studio as a multi-perspective tool for administration and development, learn to add systems, use archive links, and navigate backups, catalogs, content, and security.

Learn how to start and stop SAP HANA systems and tenants using HDB, sapcontrol, and the HANA cockpit, including credentials and maintenance workflows.

Learn to configure the SAP HANA database by managing system properties across default, system, database, and host layers, using cockpit or studio, and avoiding OS file edits.

Learn to perform regular SAP HANA database administration tasks, including system health checks, backups of SYSTEMDB and tenant DB, and monitoring alerts and performance.

Explore SAP HANA mini checks, a collection of SQL statements for extended analysis beyond standard tools, import and execute checks, then interpret results using _SYS_STATISTICS data.

Learn to configure and manage SAP HANA traces across cockpit, studio, and web IDE, including database trace, SQL trace, expensive SQL trace, and performance traces.

Access and analyze diagnostic information and diagnostic files in SAP HANA using the database explorer to view and download traces, and learn to create full dumps for SAP analysis.

Explore how to open and use the SAP HANA SQL console, add databases, browse catalogs, tables, schemas, procedures, and enable expensive SQL tracing with user filters.

Learn SAP HANA table administration by comparing column store and row store tables, focusing on partitioning, memory implications, and when to use each; including alter table conversions and export/import.

Explore SAP HANA backup and recovery capabilities, including data and log persistence layers, save points, redo logs, various backup destinations, and third-party tool integration.

Explore backup strategies for multitenant SAP HANA, planning independent backups for system and tenant databases with full, differential, incremental, and log backups and recovery scenarios.

Learn to configure SAP HANA database backups using studio or cockpit, including complete, differential, and incremental backups, with scheduling, log backups, and backup catalogs.

Explore SAP HANA database recovery with full, delta, and incremental backups, log backups, and point-in-time options to reach the most recent consistent state or a specific time.