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 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)
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 Management, Administration Guide
- Workloads, Cockpit Guide
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
- Memory Analysis, Cockpit Guide
- Memory Usage in the SAP HANA Database, Administration Guide
Recommended KBAs
- 1999997 – FAQ: SAP HANA Memory
- 1984422 – How-To: Analyzing SAP HANA Out-of-memory (OOM) Dumps
- SAP HANA Memory Usage Explained (PDF) – Bendelac (2017)
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
- Viewing the Native Storage Extension Buffer Cache Monitor, Cockpit Guide
- SAP HANA NSE Buffer Cache, Administration Guide
Recommended KBAs
- 2799997 – FAQ: SAP HANA Native Storage Extension (NSE)
- SAP HANA Native Storage Extension Whitepaper (2019, whitepaper)
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
- Monitoring Memory Paging for Non-Partitioned Table, Cockpit Guide
- Viewing and Modifying Load Unit Configuration, Cockpit Guide
- Changing the Load Unit Using ALTER TABLE, Administration Guide
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.
- Statement Performance, Cockpit Guide
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
- Authorizations Needed for Monitoring and Administration, Cockpit Guide
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
- LinkedIn > linkedin.com/in/dvankempen
- Twitter > @dvankempen
For the author page of SAP Press, visit
For the SAP HANA Cloud e-bite, see