Course announcements

  • 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.

Learning outcomes

  • This course will prepare you to:
    • 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.

Content

  • 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

Audience

  • Database Administrator
  • Help Desk/CoE Support
  • System Administrator
  • Technology Consultant

Course Based on Software Release

  • SAP HANA 2.0 SPS07

Notes

  • In case you need to "deep-dive" on specific subjects, this course can be coherently combined with the other courses in the SAP HANA curriculum, for example HA201 for high availability and disaster tolerance, and HA250 for database migration.

Course information

Languages

Available in English
Download course index Get a detailed overview of all topics, lessons, and modules covered in the course.

Prerequisites

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

Find a course date

Can't find a suitable date?

Booking for 1-2 people?

Make a request for us to schedule training around what works for you? We will do our best to consider your request.

Request a training date

Booking for 3+ people?

Our 3 to RUN initiative empowers you to schedule our chosen classroom training course or virtual SAP Live Class on a date that suits you. You need at least three confirmed participants to register and SAP will add it to your schedule.

Find out more

Languages

Available in English
Download course index Get a detailed overview of all topics, lessons, and modules covered in the course.

Prerequisites

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