Technical Articles
A deeper insight into Threads tab in studio which can be used for automation
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!