In the upcoming weeks, we will be posting new videos to the SAP HANA Academy to show new features and functionality introduced with SAP HANA 2.0 Support Package Stack (SPS) 00.
The topic of this blog is performance monitoring and analysis.
For the complete list of blogs by the SAP HANA Academy for SAP HANA 2.0, see: https://blogs.sap.com/2016/12/01/whats-new-with-sap-hana-2.0-sps-00-by-the-sap-hana-academy/
SAP HANA Cockpit
In the previous blog post about system administration, we have already discussed the new SAP HANA cockpit 2.0. As part of the new release, most of the performance management tools have received enhancements. This includes the following tools:
- Performance Monitor
- Monitor Statements
- Expensive Statements
- SQL Plan Cache
Capture and Replay
Capture and replay workloads can help you evaluate potential impacts on performance or stability after a change in hardware or software configuration. This feature was introduced with SAP HANA 1.0 SPS 12 and has been enhanced for SAP HANA 2.0.
For those not familiar with capture and replay, there is a video on the SAP HANA Administration playlist that provides a brief introduction (we will update the video for SAP HANA 2.0 soon):
The new features for the capture and replay tool are:
- Capture Overwrite
- Compare Replayed Workloads
- Replay Report and Load
Capture overwrite enables to set the condition, either on time or on disk usage, for capture overwrite to occur. This allows you, for example, to capture the daily workload but only keep and process the capture under exceptional circumstances.
Capture compare allows you to compare a target capture against a baseline, per SQL statement and with a graph for the system load.
The Load graph shows for a large number of KPI’s system workload statistics.
The new SQL Analyzer tool shows detailed information for selected SQL queries to help you tune or troubleshoot performance.
You access the tool from the new Database Explorer or from the Monitor Expensive Statement / Plan Trace.
In SAP HANA 2.0, we now have two different workload analyzers:
- Based on Thread Samples (enhanced)
- Based on Engine Instrumentation (new)
The new analyzer works with the captures from capture and replay. The workload analyzer based on thread samples uses more recent system statistics.
The analysis can be performed on a broad number of dimensions and services and a large number of KPIs.
For more information see:
- SAP HANA Administration on sap.com > Products > SAP HANA > Capabilities
- Upgrade Your SAP HANA Platform with Capture and Replay Performance Management
SAP Help Portal
- SAP HANA Performance Monitoring and Analysis (New and Changed) – SAP HANA Release Notes
- Capturing and Replaying Workloads – SAP HANA Administration Guide
- 2380257 – SAP HANA Platform 2.0 SPS 00 Release Note
- 2380291 – SAP HANA 2.0 Cockpit Central Release Note
- 2362820 – SAP HANA Performance Management Tools
Thank you for watching
The SAP HANA Academy provides free online video tutorials for the developers, consultants, partners and customers of SAP HANA.
Topics range from practical how-to instructions on administration, data loading and modeling, and integration with other SAP solutions, to more conceptual projects to help build out new solutions using mobile applications or predictive analysis.
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