SAP HANA SPS 12 What’s New: Performance Monitoring – by the SAP HANA Academy

Introduction

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 Support Package Stack (SPS) 12.

For the complete list of blogs see: What’s New with SAP HANA SPS 12 – by the SAP HANA Academy

The topic of this blog is performance monitoring.

For the SPS 11 version, see SAP HANA SPS 11 What’s New: Performance Monitoring – by the SAP HANA Academy.

What’s New?

SAP HANA Performance Monitoring Apps

SAP HANA Performance Monitoring is a new tile catalog available in SAP HANA cockpit with the deployment of the new Workload Replay delivery unit.

In this tile catalog, three new apps have been included:

• Capture Workload
• Replay Workload
• Analyze Workload

Capturing and replaying workloads from an SAP HANA system can help you evaluate potential impacts on performance or stability after a change in hardware or software configuration.

Possible use cases are:

• Hardware change
• SAP HANA revision upgrade
• SAP HANA INI parameter change
• Table partitioning change
• Index change
• Landscape reorganization for SAP HANA scale-out systems

For a complete overview, see Capturing and Replaying Workloads – by the SAP HANA Academy

Tutorial Video

SAP HANA Academy – SAP HANA SPS 12: What’s New? – Capture and Replay Workloads – YouTube

SAP HANA Administration Apps

Several apps in the SAP HANA Database Administration catalog of the SAP HANA cockpit have been enhanced for performance monitoring features.

Performance Monitor

Select Export All in the footer bar in the Performance Monitor app to export KPI data as a single data set. This ZIP file can be imported into the new Support app (Support Tools tile). You can also save your own set of KPIs using the new variant Custom, and select Show Jobs to display jobs above the load graph to show which jobs had an effect on your system performance.

Import and Export of Performance Data for Support Process

To analyze and diagnose database problems, you can now import performance monitor data from a ZIP file into SAP HANA cockpit. You can export data using the Performance Monitor app.

Threads

You can now monitor for long-running threads and analyze quickly any blocking situation using the Threads app. The tile indicates the number of currently active and blocked threads.

Statements Monitor

The Monitor Statements tile indicates the number of long-running statements and blocking situations. The app displays information about the memory consumption of statements. New for SPS 12 is that Memory Tracking can be enabled or disabled in the footer bar. Memory tracking is required for Workload Management.

Workload Management Configuration

Manage all workload classes using the new Workload Classes app. Workload classes and workload class mappings can be created to configure workload management for the SAP HANA database. Memory tracking needs to be enabled for workload management.

Documentation

A new paragraph has been added to the SAP HANA Troubleshooting and Performance Guide about network performance and connectivity problems.

The following topics are addressed:

• Network Performance Analysis on Transactional Level
• Stress test with SAP’s NIPING tool to confirm the high network latency (or bandwidth exhaustion)
• Application and Database Connectivity Analysis
• SAP HANA System Replication Communication Problems
• Analysis steps to resolve SAP HANA inter-node communication issues

Additional Information

Help Portal: SAP HANA Platform Core SPS 12

• SAP HANA Performance Monitoring (New and Changed) – What’s New in the SAP HANA Platform (Release Notes) – SAP Library
• Capturing and Replaying Workloads – SAP HANA Administration Guide – SAP Library
• Managing Workload Classes in SAP HANA Cockpit – SAP HANA Administration Guide – SAP Library
• Analyze Threads – SAP HANA Administration Guide – SAP Library
• SAP HANA Troubleshooting and Performance Analysis Guide – SAP Library
• Export Performance Monitor Data – SAP HANA Administration Guide – SAP Library

SAP Notes

• 500235 – Network Diagnosis with NIPING
• 1999993 – How-To: Interpreting SAP HANA Mini Check Results
• 2081065 – Troubleshooting SAP HANA Network
• 2114710 – FAQ: SAP HANA Threads and Thread Samples
• 2213725 – How-To: Troubleshooting of -10709 errors

SCN Blogs

Capturing and Replaying Workloads – by the SAP HANA Academy