Hello and welcome to the SAP HANA Academy.
The topic of this video tutorial series is SAP HANA Administration and in this video
we will take a look at blocked transactions.
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.
In the Monitoring section here we find a number of links and one of them is Open blocked transactions.
Select it and the Blocked Transactions app will open.
There is a lot of information on this screen, returned by the view.
So, let’s first zoom out a bit with my browser.
I hope your eyesight can handle this, and then
Well, let’s first take a look at the column selector, the gear icon here in the table
header.
As you can see, there are a lot of columns we can select, we are not seeing half of it.
For some columns, you will get a More link, so you can view, in case of the thread detail
column, for example, the actual SQL statement.
I should also point out the Hide Sessions selector here, next to the column selector.
Should you have a lot of blocked transactions, you can filter then here on Own sessions,
Idle sessions, and HANA Studio sessions, or you can search for them using a Quick Filter.
Just like for many of the other views, we can define the refresh interval here in the
top header.
Then we have the related apps for Blocked Transactions: Sessions, Threads and Monitor
Statements.
Related apps is new in SP08, alternatively, we can also select one of the blocked transactions
and then select Navigate To … on the toolbar below.
Here we can then choose between threads and sessions with the same connection ID, the
one we selected.
If you navigate to the thread, the Threads view will open and here, for example, you
can investigate the Call Stack.
Typically, this is for Support purposes, not everybody is familiar with ptime and TrexThreads.
From here you can navigate back again to the Blocked Transactions view or the Sessions
view.
It is the same view, and in the Sessions view, you could, for example, Cancel the Session
from the toolbar.
The view, by the way, let me switch to the SAP HANA Database Explorer, and open the Statement
Library for the HA0 instance, Blocked Transactions, shows a list, if we select that here, we can
execute it in the SQL Console.
Gives much of the same information.
You can edit the view.
Monitoring Blocked Transactions is documented in the SAP HANA Administration Guide and in
the Blocked Transaction Monitoring topic of the SAP HANA Troubleshooting and Performance
Analysis Guide.
For more detailed information, I can also recommend SAP Note 1 five 9s 8 - FAQ: SAP
HANA Lock Analysis.
Here you will find a lot of information.
OK —That’s it for Blocked Transactions.
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.