/
Browse
/
Courses
/
SAP HANA - Monitoring and Performance Tuning
/
Analyzing Structural System Performance Root Cause
Performing Emergency Analysis and Troubleshooting
Performing Handling System Offline Situations
55 min
Handling System Hang but Reachable Situations
10 min
Analyzing a Suddenly Slow System
45 min
Quiz
Analyzing Structural System Performance Root Cause
Analyzing Memory Issues
10 min
Analyzing CPU Issues
15 min
Analyzing Expensive Statement Issues
10 min
Analyzing Disk and I/O Issues
10 min
Quiz
Implementing Proactive Monitoring and Performance Safeguarding
Setting up SAP HANA Workload Management
1 hr 5 min
Using SAP HANA Capture and Replay
15 min
Quiz
Performing Emergency Analysis and Troubleshooting
Performing Handling System Offline Situations
55 min
Handling System Hang but Reachable Situations
10 min
Analyzing a Suddenly Slow System
45 min
Quiz
Analyzing Structural System Performance Root Cause
Analyzing Memory Issues
10 min
Analyzing CPU Issues
15 min
Analyzing Expensive Statement Issues
10 min
Analyzing Disk and I/O Issues
10 min
Quiz
Implementing Proactive Monitoring and Performance Safeguarding
Setting up SAP HANA Workload Management
1 hr 5 min
Using SAP HANA Capture and Replay
15 min
Quiz
Knowledge quiz
It's time to put what you've learned to the test, get 7 right to pass this unit.
1.
Which SAP HANA information sources inform you about high CPU consumption on your SAP HANA database?
There are three correct answers.
The host CPU usage Alert number 5
The CPU graph on the CPU usage card
The Alerts card in the Overview screen
The Services card
2.
Which tools can you use to monitor the Average Execution Time of individual SQL queries?
There are two correct answers.
Monitor Statements - Overview tab
Monitor Statements - Active Statements tab
Monitor Statements - Expensive Statements tab
SQL plan cache tab
3.
In SAP HANA, performance issues are nothing to worry because the whole database is running in-memory.
Choose the correct answer.
True
False
4.
Which KPIs are shown, by default, in the Performance Monitor started from the Memory Usage card in SAP HANA Cockpit 2.0?
There are two correct answers.
Total resident memory
Physical memory size
Used resident memory
Database free memory
5.
Which operations in the SAP HANA database result in disk I/O on the Redo Log Volume?
There are two correct answers.
Database restart
Column table reload
Scale-out host failover
Database data backup
6.
The statistics service is a central element of the internal monitoring infrastructure of SAP HANA. It collects statistical and performance information using SQL.
Choose the correct answer.
True
False
7.
The SQL Statements card displays the number of blocked transactions currently on hold in the database.
Choose the correct answer.
True
False
8.
A disk-full event causes the SAP HANA database to stop and the problem must be resolved before database operations can continue.
Choose the correct answer.
True
False