Skip to main Content

SAP HANA Using Monitoring and Performance Tools

  • Course Code HA215
  • Duration 2 days

Public Classroom Price

£1,440.00

excl. VAT

Request Group Training Add to Cart

Course Delivery

This course is available in the following formats:

  • Company Event

    Event at company

  • Public Classroom

    Traditional Classroom Learning

  • Virtual Learning

    Learning that is virtual

Request this course in a different delivery format.

Course Overview

Top
In this course you will learn about emergency trouble shooting the SAP HANA database system using the SAP HANA cockpit 2.0. You will also learn how to use the SAP HANA traces to investigate for expensive SQL statements that might cause SAP HANA database performance problems in the areas of memory, CPU, and disk I/O. You will also learn how to setup SAP HANA workload management and SAP HANA capture and replay tools to perform proactive monitoring and performance safeguarding.

Course Schedule

Top
    • Delivery Format: Virtual Learning
    • Date: 12-13 February, 2026 | 8:00 AM to 4:00 PM
    • Location: Virtual (GMT Standa)
    • Language: English

    £1,440.00

    • Delivery Format: Virtual Learning
    • Date: 07-08 April, 2026 | 8:00 AM to 4:00 PM
    • Location: Virtual (GMT Standa)
    • Language: English

    £1,440.00

    • Delivery Format: Virtual Learning
    • Date: 28-29 May, 2026 | 8:00 AM to 4:00 PM
    • Location: Virtual (GMT Standa)
    • Language: English

    £1,440.00

    • Delivery Format: Virtual Learning
    • Date: 10-11 August, 2026 | 8:00 AM to 4:00 PM
    • Location: Virtual (GMT Standa)
    • Language: English

    £1,440.00

    • Delivery Format: Virtual Learning
    • Date: 19-20 October, 2026 | 8:00 AM to 4:00 PM
    • Location: Virtual (GMT Standa)
    • Language: English

    £1,440.00

    • Delivery Format: Virtual Learning
    • Date: 17-18 December, 2026 | 8:00 AM to 4:00 PM
    • Location: Virtual (GMT Standa)
    • Language: English

    £1,440.00

Target Audience

Top

- Database Administrator

- Help Desk/CoE Support

- System Administrator

- Technology Consultant

Course Objectives

Top
  • Use the SAP HANA cockpit to perform emergency trouble shooting, the SAP HANA traces to investigate for costly statements and to setup SAP HANA workload management and SAP HANA capture and replay tools.

Course Content

Top
  • Emergency Analysis and Troubleshooting using SAP HANA cockpit 2.0
    • Handling System Offline Situations
    • Handling System Hanging but Reachable Situations
    • Analyzing a Suddenly Slow System
  • Structural System Performance Root Cause Analysis
  • Analyzing Memory Issues
  • Analyzing CPU Issues
  • Analyzing Expensive Statements Issues
  • Analyzing Disk and I/O Issues
  • Proactive Monitoring and Performance Safeguarding
  • Configuring SAP HANA alerting framework
  • Setting up SAP HANA workload management
  • Using SAP HANA capture and replay

Course Prerequisites

Top

Essential:

  • HA200 - SAP HANA 2.0 - Installation and Administration
  • Basic experience with the Linux operating system


Recommended:

  • HA150 - SAP HANA 2.0 - SQL and SQLScript for SAP HANA

Further Information

Top

Course based on software release:

- SAP HANA 2.0 SPS07