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 for Workload Management.
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.
Workload Management is nothing new in SAP HANA Cockpit, in fact, the functionality is
much older than our administration tool, going back to 2014, SPS 09, SAP HANA 1.0 and even
before for some of its features like memory or CPU usage limitation for individual processes.
The idea, the concept, is simple.
As SAP HANA combines both transactional processing (OLTP) and analytical OLAP-type queries in
a single in-memory database, you might want to have some way of guaranteeing proper response
times for both type of use cases.
This is the purpose of Workload Management and Workload Classes.
We will cover this topic in more detail in subsequent videos, but for now, let’s do
a quick tour and, at the same time, take a look at what’s new.
You open the Workload app from the System Overview page, Database Administration, Manage
workload classes.
Note that memory tracking needs to be active for statement memory limits.
So, let’s switch that on first.
Yes.
Otherwise you can only work on the global level, cumulative, everything combined.
Here we can edit our global limits.
First, you would select between total aggregated and individual statement limits, which we
just enabled.
You can specify a memory limit for each type, a thread limit, each connection can spawn
a number of threads but the total pool is not exhaustible, so you might want to limit
this, and also, new for SAP HANA 2.0 SPS03, query timeouts in seconds.
OK
Similarly, we can define user-specific parameters.
This enables us to change the default priority and statement memory limit for a specific
database user.
Maybe the administrator, maybe a particular manager, a technical user, you name it.
From the header, we can also enable and configure Admission Control.
Again, this is not a new feature.
Admission control was introduced in SAP HANA 2.0 SPS00 December 2016.
Just showing you where you can configure this.
As indicated, with admission control you can either queue or reject new requests based
on CPU and memory resource tracking statistics.
We have quite some fine tune options here under Advanced for queue management and statistics
collection.
OK —Going back.
We create our workload classes here, with Create.
Now, what’s new for Cockpit SP08, is that we can now also specify the statement memory
limit and the statement thread limit in percentages.
So in absolute values and in percentages.
This might make it easier for you get the limits right.
Three required parameters, workload class name, execution priority and limit type.
I am just making up something here.
Then, for the memory limit, I am going to use a percentage, and note that you now need
to choose between Total physical memory, the Global allocation limit or the Process allocation
limit.
Let’s do Global.
For threads the same, but this time we need to choose between Total number of cores, CPU
cores allocation limit or Cores per socket.
Then, let’s also define the Query Timeout.
Optionally, we can define a mapping so that the system can match the workload class to
a particular application user name, a client, a component, or database user, maybe a technical
user, for example.
OK - Create, and here we have our workload class.
There is new another feature, I would like to show you here.
Import Results.
Say, we want to import workload classes from our development system where we fine tuned
them to production.
You export the class or classes as a zip file from the same menu bar, here.
We can then do our import.
Browse to the zip file and now we need to make a selection: what to do when the class
or mapping already exists?
Do not import, only import classes or mappings that are not duplicates, overwrite, or first
delete everything.
Let’s pick overwrite.
Fair enough, and when the import has finished, we now get a nice report about the result,
so we know exactly what has happened.
This is a new, the Import Results screen.
Close.
OK —so much for what’s new.
There is online help for Workload Management accessible here from the toolbar.
The topic is also documented, of course, in the SAP HANA Administration Guide, and there
is support note 2222250, the SAP HANA Workload Management FAQ from SAP Support, also quite
informative, plus you”ll find some presentations from TechEd and other events on the sap.com
website.
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.