Services

SAP HANAPerformance, operations and migration

I analyse memory and performance problems in SAP HANA, migrate SAP systems to HANA and look after operations – from installation and upgrades to backup, system replication and automated monitoring.

Discuss your project

Typical situations

When HANA expertise is needed

  • SAP HANA is running out of memory

    Analysing which components, tables and processes are using the memory – and fixing the root cause.

  • The HANA system is getting slower

    Performance analysis of resource consumption, partitioning of large tables and archiving.

  • The database is growing faster than planned

    Analysis of growth and resource usage as a basis for archiving and capacity planning.

  • A migration from Oracle or DB2 to SAP HANA is due

    Migrating ERP, CRM and BW systems with DMO – also combined with the move to S/4HANA.

  • Revisions and upgrades are overdue

    Applying HANA patches and revisions; planning and carrying out upgrades from HANA 1.0 to 2.0.

  • Backup, recovery and replication need to be dependable

    Setting up and testing backup infrastructure, system replication and high availability.

  • Errors in HANA or XSA cannot be clearly attributed

    Systematic troubleshooting across database, Linux system and SAP application.

  • Installation and monitoring should be automated

    Script-based installation, updates, system copies and monitoring with Python and shell.

Scope

What I take on

From individual analyses to ongoing support – for single-node and multi-node systems, including multi-tenant setups.

  • Performance and memory

    Finding and removing bottlenecks.

    • Analysis of memory and resource consumption
    • Troubleshooting out-of-memory situations
    • Table partitioning and archiving
    • Monitoring with HANA Cockpit, automated alerts and reports

  • Installation, patches and upgrades

    Keeping HANA and the Linux system underneath it up to date.

    • Installation of single-node and multi-node systems, multi-tenant, XSA
    • Revisions, patches and upgrades from HANA 1.0 to 2.0
    • Installation and updates of SUSE Linux Enterprise Server and Red Hat Enterprise Linux

  • Migration to SAP HANA

    Moving existing SAP systems to HANA.

    • Migration of ERP, CRM and BW with DMO
    • Combined with an upgrade, Unicode conversion or the move to S/4HANA
    • Source databases Oracle and DB2

  • Availability and security

    Backing up, restoring and protecting data.

    • Backup and restore, system copies
    • System replication, scale-out and high availability
    • Encryption and SSL
    • Automation of backup, monitoring and administration

Technical depth

SAP HANA together with Basis and Linux

A HANA problem often shows up in the SAP application, while its cause lies in memory, in the Linux system or in individual tables and processes. Because my background is in SAP Basis and database administration, I do not look at HANA in isolation but as part of the whole system.

Many years of working with SAP HANA have given me a detailed understanding of its in-memory architecture and of how to use its parallel processing efficiently.

Database
SAP HANA 1.0 and 2.0 – single-node and multi-node (scale-out), multi-tenant, XSA.
Operating system
SUSE Linux Enterprise Server and Red Hat Enterprise Linux, including VMware environments.
SAP applications on HANA
SAP ERP, S/4HANA, BW, CRM, Solution Manager and Fiori server.
Tools
HANA Cockpit, HANA Studio; integration into existing monitoring such as Nagios.
Development and automation
SQL and SQLScript; Python and Bash scripts for installation, monitoring, backup and administration.

Project experience

Selected projects

Anonymised examples from my HANA work.

  • Industrial group

    Automating HANA installation and administration

    Situation
    HANA installations, updates and system copies are to run in a standardised, repeatable way.
    Task
    Automation of installation, updates, scale-out and administration tasks.
    My contribution
    Bash and Python scripts for installation, updates, scale-out, system copies and user management; high availability with the Storage API and replication; SSL setup, troubleshooting and performance tuning.

  • IT service provider

    Upgrade and out-of-memory analysis

    Situation
    A HANA environment with a multi-node, multi-tenant configuration needs an upgrade and an analysis of out-of-memory errors.
    Task
    Database upgrade plus error and performance analysis.
    My contribution
    HANA upgrade, analysis and resolution of the out-of-memory situations, performance analysis and installation of the Fiori server.

  • IT service provider

    Operation and performance of SAP HANA systems

    Situation
    SAP HANA systems, some with XSA, run on Red Hat Enterprise Linux and have to be operated reliably.
    Task
    Administration, troubleshooting and performance optimisation of the HANA systems.
    My contribution
    Performance tuning and troubleshooting, encryption, backup and restore, automated Linux installation, and monitoring with Python and shell scripts.
More project experience

Scope and connections

Three services, clearly defined

  • SAP Basis

    HANA is the database underneath your SAP system. Upgrades, system copies and transport management of the SAP systems themselves belong to SAP Basis.

  • SAP HANAThis page

    Everything around the SAP HANA database: memory, performance, operations, high availability and the migration to HANA.

  • Data Migration & Transformation

    A migration to HANA changes the database of an existing system. Transferring business data into new structures is a separate task.

Contact

Let’s talk about your HANA system.

Whether it is memory problems, an upcoming upgrade or the migration to HANA: a short description of your environment and the problem is enough for an initial conversation.

Discuss your project