Hello and welcome to the SAP HANA Academy.
The topic of this video tutorial series is SAP HANA Administration and in this video
I will show you how you can work with the SAP HANA cockpit Performance Monitor.
This video has been recorded on release SAP HANA cockpit 2.0 SP08 from October 2018.
For earlier or later releases, please check the playlist on the SAP HANA Academy.
Hi, I am Denys van Kempen.
I am connected here to the SAP HANA cockpit, connected to a tenant database, HA0, and we
are looking at System Overview.
CPU Usage, Memory Usage, and Disk Usage give us an instant overview of the most important
KPIs, the most important key performance indicators.
CPU Usage shows current processor usage with a percentage used high water mark.
Memory Usage shows Used Memory in a bar graph: used, peak used and the allocation limit,
and another one for the resident memory: database and total resident memory and the total amount
of physical memory.
Total amount of physical memory is just the amount of system memory (of RAM) your system
has been configured with; this is the hardware.
Resident memory is the amount of physical memory that SAP HANA processes, processes
like the indexserver, nameserver, and so on, are currently using.
Here that would be about 24 GB for systemdb and the tenants and about 60 GB for the XS
Advanced runtimes and all of the applications.
Disk Usage shows the size of the disk with the identifier, again hardware, although this
could very well be a logical volume.
With total usage, usage for the database, for the redo log files and for the trace files.
All three tiles have a link to the Performance Monitor app and also to the Analyze Workloads
app (as of cockpit SP 08).
For Disk Usage it is hidden here under the ellipsis.
If you click any of the Usage apps, or click the Monitor Performance link, the Performance
Monitor app opens.
Let’s open the CPU Usage view.
There are several ways how you can customise the view.
You can select any of the predefined views.
To focus, you can select the counter in the legend.
If you hover over the chart, you get the actual data for that counter at a particular timestamp.
If you change the counter, the data type of the Y axis will change accordingly.
To create your own chart using the current chart as a template, select Settings, the
gear icon in the header bar menu.
First select the host and services.
Here we only have a single host.
I n case of a distributed or multiple host system, the list can be quite long.
If you only want the cumulative statistics, just select the host.
If you want the statistics for a particular process, if you want to able to drill down,
also select the different processes.
There is a video tutorial about the SAP HANA architecture, about the processes, here on
this playlist.
Then select the KPI.
They are ordered by type.
Host KPIs are Linux statistics, similar what you would get with commands like top.
Service KPIs report the metrics for individual services, the different database and application
server, XS Advanced, processes.
CPU used by Service
Memory used by Service
Open SQL connections, this would only apply to the indexserver and nameserver processes,
for example.
Number of active MVCC versions, Multiversion Concurrency Control —if I am updating a
table but have not yet committed, you want to view the table as it was, not my version
because my transaction might fail, and if other sessions are making changes they want
their own versions too, so with multiple tables involved this can get pretty complex, pretty
soon.
There is information about connections, about transactions, locks, and threads, and read
and write times, for data, for log, for backup, and so on.
Let’s remove the service selections.
And add all the host counters.
OK
Our Default view now has a star.
Which we can Save As.
Host.
OK
And now we have created an additional view.
We can manage this view.
Change the name, or delete it.
Another way to customise the view is by changing the time interval.
We can select this here from the calendar.
Or, a bit easier, just pick any of the presets.
If you want the data to automatically update, select Refresh and specify the refresh rate.
To zoom in, you can create a time period selection.
You can do this in the preset view.
Click and drag.
The scale allows you to open the selection in the Performance Comparison app.
You can pin or hide the preset view.
In the main chart, we can also make our selection to zoom in further, or add this to Performance
Comparison.
You can move your selection or adjust its size.
To zoom out, to undo, click undo in the header.
Click the scale to open it in Performance Comparison.
To compare we have to add a chart first.
Click the link.
We get the same presets we saw previously.
We can adjust the time range of the second graph using the calendar
and the presets again
But we can also switch to a relational view and add or substract a day, an hour or minutes.
If we now make a selection, we can open this once again in either Performance Monitor or
Workload Analysis but we can also bookmark the selection.
Add a description, or delete it when you are done.
In the header, we can refine the KPIs, add some more, and change host & services.
Add Chart allows you add another view, maybe add a longer or shorter period.
Click Remove to remove it.
Let’s go back to Performance Monitor.
Here we also have the option to add a chart.
However, here we get the same selector as when using the Settings menu.
Give the chart a name, select host & services, and select the KPIs.
Here we can also make our selections, works the same way.
We can export data, this will be a complete snapshot, not related to the current view,
the time frame or KPIs selected, and this will be typically for support purposes.
SAP Support might request an export when investigating issues.
The export can run in the background, the data will be save in a compressed archive:
load_history.zip
Of course, you can also make your own exports and then you would use import to import the
file.
This allows you to view data from other systems.
Opens the Support Tools view.
Any previously imported set will be listed here.
To load the set, click the link.
To remove, click the cross.
To import a new set, click Import.
You can import local files, so the file you just exported, but also remote files, and
for this you need to enter the path to the nameserver history trace file.
Enter a description and select Import.
You can then click the link, to load the data set, takes a few seconds.
Then we also have an info icon here for System Information.
This is very detailed, mostly for support purposes as well, I would think.
Here we find not only the SID and instance number but also hardware information; data
about out the SSFS, the Secure Store in the File System, master keys and the cryptography
provider used.
Operating system information
The HANA build with branch, compiler, Git Hash
CPU, memory, and network.
We can navigate to Workload Analysis and Performance Comparison but I expect these links to disappear
because, as of cockpit SP08, we can also do this from the header, lateral navigation,
and select related apps.
To access the documentation, finally, you can select the help icon.
This will open the Administration Guide for this topic.
That’s it.
Performance Monitor.
Thanks for watching.
You can find more video tutorials on our YouTube channel.
If you would like to be informed about new video tutorials, please subscribe to our channel.
You can connect with us on LinkedIn or follow us on Twitter, as well for updates, and if
you are watching this video on YouTube, do not hesitate to leave your comments to the
video page and, if you like, give us your vote on this video.
Thank you for watching.