Skip to Content
Product Information

SAP HANA Cloud: What’s New (and Changed) – Monitoring Session, Threads, and Statements

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

Any good? Post a comment, share on social media, and/or give a like. Thanks!

/wp-content/uploads/2016/02/sapnwabline_885687.png

Video Tutorial

In this second video tutorial about monitoring SAP HANA Cloud with SAP HANA cockpit, we take a look at the remaining cards and apps

  • Sessions
  • Threads
  • Blocked Transactions
  • Monitor Statements
  • Table Usage

What’s Changed?

Compared to the SAP HANA cockpit for SAP HANA platform (on-premise), the following changes have been made:

  • Configure Expensive Statement Trace is removed from Monitor Statements as file-based tracing is no longer available for SAP HANA Cloud.

 

SAP HANA Cloud – SAP HANA Cockpit: Sessions and Threads

/wp-content/uploads/2016/02/sapnwabline_885687.png

System Overview

Monitoring Sessions, Threads, and SQL Statements

The Monitoring and Administration topic area in System Overview includes

  • Sessions
  • Threads
  • Top SQL Statements (Monitor Statements)
  • Monitoring: Open blocked transactions
  • Monitoring: Monitor Table Usage

When selected, the cards open the corresponding related apps with the same name.

For the documentation, see

System Overview

/wp-content/uploads/2016/02/sapnwabline_885687.png

Sessions

The Sessions app enables us to monitor session activity in the database with detailed information about each session (34 different statistics available for selection). The Summary header shows several aggregates (Top 5). When a session is selected, we can cancel the session (requires SESSION ADMIN system privilege) or navigate to the Threads or the Blocked Transactions app with the same connection ID.

For the documentation, see

Recommended KBAs

Sessions

/wp-content/uploads/2016/02/sapnwabline_885687.png

Threads

The Threads app enables us to monitor thread activity in the database with detailed information about each thread (57 different statistics available for selection). The Summary header shows several aggregates (Top 5). When a thread is selected, we can cancel the operation (requires SESSION ADMIN system privilege) or navigate to the Sessions or the Blocked Transactions app with the same connection ID. In addition, we can request the call stack for a particular thread (use case: SAP Support request).

Recommended KBAs (lists and describes the different type of threads available)

Threads

/wp-content/uploads/2016/02/sapnwabline_885687.png

Blocked Transactions

The Blocked Transaction app enables us to view details information about blocked transactions, when available (51 different statistics available for selection). When a transaction is selected, we can navigate to the Sessions or the Threads app with the same connection ID.

Recommended KBAs

Blocked Transactions

--session 1:
CREATE TABLE X (A INT);
INSERT INTO X VALUES (0);
COMMIT;
-- setting 10 minute timeout
SET TRANSACTION LOCK WAIT TIMEOUT 600000;
UPDATE X SET A = 1;   

--session 2:
SELECT A FROM X FOR SHARE LOCK

Simple Test Case

Related Apps

Sessions, Threads, and Blocked Transactions are related apps and we can easily navigate between the apps by using either the lateral navigation menu in the header or the context aware Navigate To … menu in the footer which preserves the connection ID.

Lateral Navigation

Navigate To…

/wp-content/uploads/2016/02/sapnwabline_885687.png

Monitor Statements

The Monitor Statement app enables us to statement activity in the database with detailed information about each statement (overview, active statements, SQL Plan Cache, Expensive Statements). The Top SQL Statement card on System Overview opens this app.

From the SQL Plan Cache tab, we can save SQL Statement execution plans as PLV files or open the plan directly in SQL Analyzer.

For the documentation, see

Recommended KBAs (lists and describes the different type of threads available)

Overview

Monitor Statements – Overview

Monitor Statements – SQL Plan Cache

/wp-content/uploads/2016/02/sapnwabline_885687.png

Table Usage

The Table Usage app displays a bubble graph (and table view) of the largest column tables in the database. A filter selection can be made on reads, writes, read/writes, and size.

For the documentation, see

Table Usage

/wp-content/uploads/2016/02/sapnwabline_885687.png

SAP HANA Database Explorer

SQL Console and Statement Library

The information displayed in the Sessions, Threads, and Blocked Transactions apps is populated from M_SESSION_CONTEXT, M_SERVICE_THREADS, and M_BLOCKED_TRANSACTIONS and related system monitoring views, which you can query using the SQL Console in SAP HANA Database Explorer.

SQL Console

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. Due to changes in the catalog, some statements return errors and require editing.

For the documentation, see

Recommended KBA

Statement Library

/wp-content/uploads/2016/02/sapnwabline_885687.png

Learned Something New?  

Post a comment, share on social media, and/or give a like. That’s how the community works. Thanks.

If you would like to receive updates, connect with me on

Best,

Denys van Kempen

/wp-content/uploads/2016/02/sapnwabline_885687.png

 

2 Comments
You must be Logged on to comment or reply to a post.