Hello and welcome to the SAP HANA Academy.
The topic of this video tutorial series is SAP HANA Cockpit and in this video we will
discuss what’s new or changed in the Performance Monitoring and Analysis topic area.
This video has been recorded on release SAP HANA cockpit 2.0 SP 08 from October 2018.
For earlier or later releases, please check the playlist on the SAP HANA Academy.
Hi, I am Denys van Kempen.
Lots of new features for analysis and monitoring for this release.
We have enhancements for the Workload and SQL Analyzer, for the Performance Monitor,
and for Capture and Replay.
I will start with Workload Analyzer.
We used to have two Workload Analyzer tiles on System Overview: one based on thread samples
and one based on engine instrumentation for use with capture and replay.
Both tiles have been removed.
For thread-based workload analysis, we can now access the app through CPU Usage, Memory
Usage or Disk Usage.
You can also access Workload Analysis from the Performance Monitor, this has been available
for some time, or, through the new lateral navigation menu, and this is a new SP 08 feature.
We will look at the engine instrumentation version for Capture and Replay in a minute.
Next, Performance Monitor.
We can now choose from three predefined KPI views, here under My Views, and also define
your own custom views.
Use the gear icon here in the header.
Make your selection, let’s remove the XS and XSA services, and then, for example, add
the Admission Control KPIs, OK.
The view now has a * indicating a changed view, so we can save it under a new name.
Admission Control
And we can manage our views here, rename and delete for the custom views.
OK — also new, we can now do remote imports of nameserver history traces.
Go to import, the upload icon, opens Support Tools, select Import on the toolbar, and then
now, you can select Remote File.
This is particularly useful for a distributed system, of course, with multiple hosts and
shared storage.
In any case, you will need to be able to access the file system, it needs to be mounted.
Couple of new features for the Performance Monitor.
Previously, we used to have a Monitor Statements app, a SQL Plan Cache app, and an Expense
Statements app.
In SP08, they have all been consolidated into Monitor Statements.
So, we have 4 tabs: Overview, Active Statements, SQL Plan Cache, and Expensive Statement Trace.
This needs to be configured, of course, otherwise you get No Data.
Then, the SQL Plan Cache has been enhanced, as well.
We can now configure the cache.
Change the size, switch it on or off and enable inter-user plan sharing, so you can access
SQL Plans of other users.
Additionally, we can also now clear the plan cache.
OK —Then, we have the SQL Analyzer.
You can now save plans to the file system of the SAP HANA server in the trace directory
as PLV file, that’s the extension, and you can give the name a prefix, so it will be
a bit easier to recognize and search.
You can also download the file, it is XML, not so easy to read, this is also not the
objective, because if we switch to the Saved Plans view, we can now also load PLV files
into the plan cache.
You can also delete files from the cache when you are done.
If we then switch to Manage Plan Stability, we now have this Advanced selector, and here
we can update locations or manually migrate ASPs.
ASP, abstract SQL plans refer to plans from another system or another system state.
When you upgrade your system, for example, you need to migrate the ASPs.
With update locations, you can change the host and port of the server.
Let’s run some SQL here in the SQL Console and then run Analyse SQL.
The SQL Analyzer is, in fact, a separate app, which can be loaded into the Database Explorer
and the SAP HANA Cockpit.
The magic of micro-services.
OK - We can now load the plan in SQL Analyzer as administrator, in cockpit.
And what we can see is that we now have SQL Performance Recommendations, a summary, here
on the overview, with a detailed recommendation below and we also have a Compilation Summary,
so we can view some of the statistics, and table accesses, tables in use, timeline and
the Plan Graph, this was available previously.
Finally, let’s take a look at Capture and Replay
And start a capture.
This will open Capture Configuration.
In the Data Collection section, we can now enable Abstract SQL Plans, we mentioned them
when discussing SQL Analyzer, to capture SQL Plans on the source instance for export to
the file system.
We can also enable SQL input parameters, you need to switch Workload Details on first,
and with this enabled, we will see the parameter values for bind variables.
In case you get good performance for certain values and not-so-good for others, this may
be of interest.
OK - Start Capture.
This will open Capture Management.
If you want to Stop the Capture, you can now just click Stop in the Capture Status column,
otherwise select the capture to open Capture Monitor and stop the capture from here, as
before.
OK —We enabled Workload Details for this capture, so we can load the workload from
here.
These are very small captures, so this go very quick but if you have longer captures
this may take some time.
Let’s make the screen a little bit smaller.
And if we now select the capture, this will open Workload Analysis.
So this is the other Workload Analysis for engine instrumentation, as it was called before.
OK —Replay Management.
Again, we can start and stop preprocessing from the Preprocess Status column and on the
Replay List we can see the status of started replays with a link for more details and should
there be a replay running, you can also stop it from here.
Then we have our Replay Report.
You can now filter Slower Statement by Elapsed, CPU or Execution Time and we have some more
enhancements, for example, on Performance Comparison you can now do your sorting directly
from the column header, same for Result Comparison.
With each release Capture and Replay is getting more comprehensive.
Very useful, indeed.
OK —What’s new in SAP HANA Cockpit 2.0 for Performance Monitoring and Analysis is
documented in the What’s New Guide.
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 you6 fr45r comments
to the video page and, if you like, give us your vote on this video.
Thank you for watching.