Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
Showing results for 
Search instead for 
Did you mean: 
Active Participant
Looking for automation options with respects to HANA threads?

Below is a deeper insight of how to read the Threads tab in out HANA DB which gives us with ample information.

CONNECTION_ID is the column name for Connections : Table Name : M_CONNECTIONS

TRANSACTION_ID is the column name for Transactions: Table_NAME: M_CONNECTIONS / M_TRANSACTIONS

THREAD_TYPE is the column name for Thread Type: Table Name: M_SERVICE_THREADS

THREAD_ID is the column name for ThreadID ;Table Name: M_SERVICE_THREADS

THREAD_METHOD is the column name for ThreadMethod; Table Name: M_SERVICE_THREADS

THRAD_DETAIL is the column name for Thread Detail; Table Name: M_SERVICE_THREADS

THREAD_STATE is the column name for Thread Status; Table Name: M_SERVICE_THREADS

CALLER is the column name for Caller; Table Name: M_SERVICE_THREADS

CALLING is the column name for Calling; Table Name: M_SERVICE_THREADS

DURATION is the column name for Duration(ms); Table Name: M_SERVICE_THREADS


Now that we know the column name involved, how can we find the associated table ?

Other associated tables for these columns can be found by querying M_CS_COLUMNS: ie, other tables from which the above data can be read are = GLOBAL_OUT_OF_MEMORY_EVENTS_BASE,HOST_LONG_IDLE_CURSOR_BASE etc

Eg: select * from M_CS_COLUMNS where COLUMN_NAME='STATEMENT_ID';


Hope it was helpful!!

Please leave a comment or suggestion!

Click on like if you found this article useful!
Labels in this area