Technical Articles
C_HANATEC_13 Topics: Monitoring and Troubleshooting – by the SAP HANA Academy
LATEST UPDATE: December, 2020 ========================================= For the latest information, visit our blog post series about SAP HANA certification: For the SAP Press Certification Success Guide, see For the blog post, see |
Introduction
This blog is part of a series to help you pass the SAP Certified Technology Associate – SAP HANA 2.0 certification exam, C_HANATEC_13.
For an overview of the exam, see
For the sample questions, see
Topic Areas
There are 10 topic areas and you can expect about 8 questions for each topic.
- Monitoring and Troubleshooting (this blog)
- Backup and Recovery
- Security
- Users and Authorization
- Database Migration to SAP HANA
- Installation and Upgrade
- System Architecture
- Multitenant Database Containers
- High Availability and Disaster Tolerance
- Database Administration Tools and Tasks
In this blog, I will discuss the Monitoring and Troubleshooting topic.
This topic is an exception to the 10% / 8 question rule as I counted a whopping 13 questions marked for this topic! Your mileage may vary but you might want to take note. It is a big topic.
On the SAP Training website for C_HANATEC_13, the exam objective for this topic is stated:
Use SAP HANA cockpit or DBA Cockpit to monitor the SAP HANA database,
configure the traces and collect diagnosis information.
On my exam there were exactly 0 questions about DBA Cockpit, but again, your exam could very well be different.
Study Material
The exam guide states that the study material for this topic comes from training
You can download the index of the guide with the units and lesson objectives from the SAP Training website.
For such an important topic you would expect a dedicated unit or lesson about monitoring and troubleshooting but this is not the case. There are two exercises for monitoring, one for HANA cockpit and one for DBA cockpit. It is covered in the units Administration Tools and in Database Administration Tasks which we discuss in another blog
The topic is also mentioned in the lesson about Memory Management and Data Persistence, for this see the blog about
For SAP HANA 2.0 SPS 02, there is a dedicated SAP Training about this topic
It might be listed for the upcoming C_HANATEC_14 on SPS 02 but it is not listed for C_HANATEC_13 (SPS00). I will discuss some of the topics of HA215 below.
There is an openSAP course on SAP HANA Administration which includes monitoring
- Introduction to SAP HANA Administration (openSAP)
There is also a TechEd recording available from Lucas Kiesow, product manager for SAP HANA
For the documentation, see
- Monitoring in SAP HANA Cockpit – SAP HANA Administration Guide
- Performance Management – SAP HANA Administration with SAP HANA Cockpit
- DBA Cockpit for SAP HANA
What’s New?
The focus will be on the new SAP HANA 2.0 features, so if you are new to this version you might be interested to view the What’s New videos first:
- SAP HANA 2.0 SPS 00 What’s New: Performance Monitoring and Analysis – by the SAP HANA Academy
- A short overview of the SAP HANA Performance Management Tools in SAP HANA 2.0 SPS00
Note that C_HANATEC_13 covers SAP HANA 2.0 SPS 00 only. C_HANATEC_14 will cover SPS 02.
Capture and Replay
The capture and replay tool is only mentioned briefly in the HA200 training so you are not expected to be familiar with this tool in any depth.
Should you be curious and want to learn a bit more: for a good introduction on the topic, see
There is also a tutorial video about capture and replay on the Academy
SAP HANA Academy – Administration: Capture and Replay
If you want to set your own test/training environment up, this guide may be of use
For the documentation, see
- Capturing and Replaying Workloads – SAP HANA Administration Guide
Workload Management
Workload management is not mentioned at all in the HA200 training so you are not expected to be familiar with this tool.
Again, should you be curious: for a good introduction on the topic, see the whitepaper and/or the TechEd talk by the product manager Ruediger Karl
For the documentation, see
- Workload Management – SAP HANA Administration Guide
References
SAP HANA Academy Playlists
SAP HANA Community Blogs
- SAP HANA 2.0 SPS 00 What’s New: Performance Monitoring and Analysis
- A short overview of the SAP HANA Performance Management Tools in SAP HANA 2.0 SPS00
- Introducing the new SAP HANA capture and replay tool, available with SAP HANA SPS12
SAP Notes
- 2362820 – SAP HANA Performance Management Tools
- 2222220 – FAQ: SAP HANA DBACOCKPIT
- 2222250 – FAQ: SAP HANA Workload Management
- 2114710 – FAQ: SAP HANA Threads and Thread Samples
- 1999930 – FAQ: SAP HANA I/O Analysis
- 2180165 – FAQ: SAP HANA Expensive Statements Trace
- 2366291 – FAQ: SAP HANA Executed Statements Trace
- 2520774 – FAQ: SAP HANA Performance Trace
SAP Help Portal (Documentation)
- Monitoring in SAP HANA Cockpit – SAP HANA Administration Guide
- DBA Cockpit for SAP HANA
- Capturing and Replaying Workloads – SAP HANA Administration Guide
- Workload Management – SAP HANA Administration Guide
Whitepapers
SAP Education
- HA200 – SAP HANA 2.0 Installation and Administration
- HA215 – SAP HANA 2.0 Monitoring and Performance (not for this exam)
openSAP
- Introduction to SAP HANA Administration (openSAP)
SAP TechEd
- HBD109 – Performance Management Tools for SAP HANA, 2017 Las Vegas
- DMM208: Workload Management for SAP HANA, 2016 Las Vegas
Thank you for watching
The SAP HANA Academy provides technical enablement, implementation and adoption support for customers and partners with 1000’s of free tutorial videos.
For the full library, see SAP HANA Academy Library – by the SAP HANA Academy
For the full list of blogs, see Blog Posts – by the SAP HANA Academy
- Subscribe to our YouTube channel for updates
- Join us on LinkedIn linkedin.com/in/saphanaacademy
- Follow us on Twitter @saphanaacademy
- Google+ plus.google.com/+saphanaacademy
- Facebook facebook.com/saphanaacademy