Skip to content
IT Canvass
SAP HANA · Lesson

Administration

Quick answer

HANA is updated through revisions/support package stacks; administrators plan and apply these (in non-production first), keeping the database supported and secure, coordinated with the SAP application layer.

Key takeaways

  • The HANA cockpit is the primary web-based administration tool: it shows system status, alerts, memory and performance, and lets…
  • Because HANA is in-memory, memory is the critical resource.
  • Monitor system health, memory, CPU, disk, services (via the HANA cockpit).
  • Watch out: Ignoring memory pressure, the key HANA resource.

What HANA administrators do

  • Monitor system health, memory, CPU, disk, services (via the HANA cockpit).
  • Manage users, roles and privileges (security).
  • Configure and monitor backups and recovery, and system replication (HA/DR).
  • Tune performance (memory management, expensive statements, table distribution).
  • Manage tenants (in multitenant systems) and apply revisions/patches.

The HANA cockpit

The HANA cockpit is the primary web-based administration tool: it shows system status, alerts, memory and performance, and lets administrators manage backups, users, and configuration. It is the day-to-day home for HANA operations.

Memory management matters most

Because HANA is in-memory, memory is the critical resource. Administrators watch memory usage, manage what is loaded/unloaded, and ensure the system stays within its licensed/physical memory, memory pressure is the characteristic HANA operational concern.

Revisions and patching

HANA is updated through revisions/support package stacks; administrators plan and apply these (in non-production first), keeping the database supported and secure, coordinated with the SAP application layer.

Common pitfalls

  • Ignoring memory pressure, the key HANA resource.
  • Unmonitored backups/replication.
  • Patching production first without testing.

Want to learn this properly?

Our live, instructor-led SAP Training covers this hands-on, with real projects and a certification path.

Check your understanding

  1. Which statement is true of Administration?

    • A. Disaster recovery (DR) is the plan for restoring SAP after the loss of an entire site or a catastrophic…
    • B. It is the day-to-day home for HANA operations.
    • C. Transaction data records the individual business events that happen every day, orders, deliveries, invoices…
    Show answer

    B. It is the day-to-day home for HANA operations.

    Covered in the “The HANA cockpit” section of this lesson.

  2. Which of these also applies to Administration?

    • A. Choosing greenfield vs brownfield without analysis.
    • B. SELECT in a loop, the classic performance killer.
    • C. Because HANA is in-memory, memory is the critical resource.
    Show answer

    C. Because HANA is in-memory, memory is the critical resource.

    Covered in the “Memory management matters most” section of this lesson.

  3. Which part of the Learn SAP curriculum covers Administration?

    • A. SAP modules hub
    • B. SAP administration
    • C. SAP HANA
    Show answer

    C. SAP HANA

    This lesson sits in the SAP HANA section of the Learn SAP course.

Frequently asked questions

What does the term Administration refer to in SAP?

HANA administration keeps the database healthy, available and performant: monitoring, user/security management, backups, performance tuning and capacity management. It is a specialised extension of Basis administration for the HANA platform.

What is the performance impact of Administration?

The HANA cockpit is the primary web-based administration tool: it shows system status, alerts, memory and performance, and lets administrators manage backups, users, and configuration.

What is the practical takeaway on Administration?

HANA is updated through revisions/support package stacks; administrators plan and apply these (in non-production first), keeping the database supported and secure, coordinated with the SAP application layer.

What tends to go wrong with Administration?

Ignoring memory pressure, the key HANA resource. Unmonitored backups/replication. Patching production first without testing.
CallWhatsAppEnquire