Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
dvankempen
Product and Topic Expert
Product and Topic Expert







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

Questions? Post as comment.

Useful? Give us a like and share on social media.

Thanks!



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)


https://www.youtube.com/watch?v=KiGd2cxJFBQ
SAP HANA Cloud - SAP HANA Cockpit: Performance


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


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


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


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


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


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


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


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


Share and Connect


Questions? Post as comment.

Useful? Give a like and share on social media. Thanks!

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

For the author page of SAP Press, visit

For the SAP HANA Cloud e-bite, see