Skip to Content
Product Information

SAP HANA Cloud: What’s New (and Changed) – Monitoring

In the upcoming days and weeks, we will be publishing new tutorial videos about what’s new and changed for SAP HANA Cloud. The focus of this series is on system administration with SAP HANA cockpit.

For the overview blog about What’s New with SAP HANA Cloud Administration, see

Any good? Post a comment, share on social media, and/or give a like. Thanks!

/wp-content/uploads/2016/02/sapnwabline_885687.png

Video Tutorial

In this video tutorial, we show how to work with the different performance monitoring cards and apps of the SAP HANA cockpit for SAP HANA Cloud. We cover

  • how to work and customise Performance Monitor views (CPU, Disk, and Memory)
  • how to use Performance Comparison
  • how to export and import performance data
  • how to navigate and use the different performance-related apps, including SQL Analyzer
  • how to use Workload Analysis (CPU, Disk, and Memory)
  • how to use Memory Analysis
  • how to use Buffer Cache Monitor and configure the buffer cache
  • how to work with Memory Paging Monitor and Load Unit Configuration

What’s Changed?

Compared to the SAP HANA cockpit for SAP HANA Service, the following apps are new:

  • Buffer Cache Monitor
  • Memory Paging Monitor
  • Load Unit Configuration

Compared to the SAP HANA cockpit for SAP HANA platform (on-premise), the following apps have been removed:

  • Memory Profiler
  • Network Monitor (system replication, multiple-host system)
  • System Health Monitor (multiple-host system)
  • Disk Volume Monitor (managed service)

SAP HANA Cloud – SAP HANA Cockpit: Performance

/wp-content/uploads/2016/02/sapnwabline_885687.png

System Overview

CPU | Memory | Disk Usage and Monitoring

System Overview displays four cards related to monitoring: CPU Usage, Memory Usage, and Disk Usage – all displaying a graph and KPI – and Monitoring with only links. When selected, all cards open Performance Monitor each with a corresponding view: CPU, Memory, Disk, and Default.

All cards also open Workload Analysis with a corresponding view but there is no default view and no way to switch views inside the app.

Memory Usage also links to Memory Analysis, Monitor Buffer Cache, Monitor Memory Paging, and Load Unit Configuration.

CPU | Memory | Disk Usage & Monitoring (card)

For the documentation, see

/wp-content/uploads/2016/02/sapnwabline_885687.png

Performance Monitor

Views

Performance Monitor views can be customised. We can add charts to a view, select key performance indicators (KPI) and include or remove the timeline. Using one of the default views as template, we can save the view or delete it when no longer needed. The header bar includes a time frame selector and presets with preconfigured intervals.

Collected data can be exported (zip file) and imported into another system for further analysis (e.g. SAP Support) or to compare different systems and environments (cloud and on-premise).

Performance Monitor (app)

KPI

For each host and each service, we can select 40+ KPIs. The current version of SAP HANA Cloud is a single host system. For a description of the services, see What’s New and Changed – System Information.

For a description of the KPIs, see

Add KPIs

Performance Comparison

We can select a time window on the time line and open Performance Comparison and add additional charts to compare service KPIs, for example with performance data imported from other systems.

Performance Comparison

/wp-content/uploads/2016/02/sapnwabline_885687.png

Workload Analysis

Workload Management

The CPU | Memory | Disk Usage cards also contain a analyse workload link that opens the Workload Analysis app, which looks and works similar as Performance Monitor except that there is no view menu in this app to change or save views.

The top pane shows the time interval. The bottom pane Top SQL Statements, Background Jobs, Timeline, and Threads.

Workload Analysis is typically used in the context of workload management and in combination with workload classes (to be addressed in a future blog). For the documentation, see

 

Workload Analysis – Top SQL Statements

Workload Analysis – Timeline

/wp-content/uploads/2016/02/sapnwabline_885687.png

Memory Analysis

Memory

We can access the Memory Analysis app from the Memory Usage card, Analysis Memory History. The look and feel of this app are similar to Performance Monitor and Workload Analysis.

The top pane shows the time interval. The bottom pane Top Consumers, Components, Allocators, Tables, and Out of Memory Events.

Out of Memory (OOM) events are also indicated on System Overview (see above).

Memory Analysis – Out of Memory Analysis

Memory analysis requires a good understanding of SAP HANA memory structures and operations like delta merges, loads, and components like the row and column stores.

For the documentation, see

Recommended KBAs

 

FAQ: SAP HANA Memory

/wp-content/uploads/2016/02/sapnwabline_885687.png

Buffer Cache and Memory Paging Monitor

We can access the Buffer Cache Monitor app from the Memory Usage card. This app displays for each table the size in-memory and in the buffer cache. By clicking the Configure Buffer Cache we can adjust the size of the cache.

For the documentation, see

Recommended KBAs

 

Manage Buffer Cache Size

/wp-content/uploads/2016/02/sapnwabline_885687.png

Memory Paging Monitor

We can access the Memory Paging Monitor and Load Unit Configuration apps from the Memory Usage card. Memory Paging Monitor displays for each table memory, buffer cache, and unloaded sizes. From the header (and from Memory Usage), we can access View Load Unit Configuration. This displays for each table whether the table is loaded in-memory or in the cache.

From the header of the app we can access the SQL Console of the Database Explorer. This enables use to manage load unit configuration using ALTER TABLE statements.

For the documentation, see

Recommended KBAs

 

Memory Paging Monitor

Load Unit Configuration

/wp-content/uploads/2016/02/sapnwabline_885687.png

SQL Analyzer

Statement Performance

From Workload Analysis, Top SQL Statements and other views a link to the SQL Analyzer is listed. This tool provides detailed information about SQL statements, execution plan, operators and a plan graph. SQL Analyzer is also accessible from the SAP HANA Database Explorer.

Recommended KBA

SQL Analyzer – Plan Graph

/wp-content/uploads/2016/02/sapnwabline_885687.png

SAP HANA Database Explorer

SQL Console and Statement Library

Although not specific to SAP HANA Cloud, the Statement Library of the SAP HANA Database Explorer also contains many statements and script that can be useful for performance analysis, including SAP HANA mini checks. Due to changes in the catalog, some statements return errors and require editing.

For view-only access, the system privilege CATALOG READ and SELECT on the _SYS_STATISTICS schema suffices. To make changes additional privileges are required. For the details, see

Recommended KBA

SAP HANA Database Explorer
/wp-content/uploads/2016/02/sapnwabline_885687.png

Learned Something New?  

Post a comment, share on social media, and/or give a like. That’s how the community works. Thanks.

If you would like to receive updates, connect with me on

Best,

Denys van Kempen

/wp-content/uploads/2016/02/sapnwabline_885687.png

 

Be the first to leave a comment
You must be Logged on to comment or reply to a post.