SAP HANA 2.0 SPS05 - Using Monitoring and Performance Tools

Popis kurzu

In this course you will learn about emergency trouble shooting the SAP HANA database using the SAP HANA cockpit 2.0 SP12. 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.

In this course you will learn about emergency trouble shooting the SAP HANA database using the SAP HANA cockpit 2.0 SP12. 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.

Určeno pro

• Database Administrator


• Help Desk/CoE Support


• System Administrator


• Technology Consultant

Obsah kurzu

• This course is the best starting point to learn about the SAP HANA Monitoring and Performance Tools.


• Contents:


• Emergency Analysis and Troubleshooting using SAP HANA cockpit 2.0 SP12




• 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

Předpoklady

Essential

• HA200 - SAP HANA 2.0 SPS05 - Installation and Administration


• Basic experience with the Linux operating system

Recommended

• HA100 - SAP HANA 2.0 SPS05 – Introduction


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

Studijní materiály