Collector for HANA Thread Info
The technical name of the Collector for HANA Thread Info is /DVD/MON_HDB_CL_COL_THREAD.
This collector collects information about HANA threads, for example the number of active threads, the duration of threads, the runtime of HANA replications, etc.
Default KPIs Delivered with This Collector
The following default KPIs are delivered with this collector:
|
KPI name |
Description |
Unit |
Detail table |
|---|---|---|---|
|
HDB_THR_BACKUP |
Maximum duration of backup threads |
S |
Yes |
|
HDB_THR_COUNT |
Number of active HANA threads |
Number |
Yes |
|
HDB_THR_JOBWRUN |
Running JobWorker threads (max. all hosts) |
Number |
Yes |
|
HDB_THR_JOBWRUNH |
Running JobWorker threads per host |
Number |
Yes |
|
HDB_THR_JOBWTTL |
Total JobWorker threads (max. all hosts) |
Number |
Yes |
|
HDB_THR_JOBWTTLH |
Total JobWorker threads per host |
Number |
Yes |
|
HDB_THR_MAXRUN |
Maximum duration of HANA threads |
S |
Yes |
|
HDB_THR_MC_CPUT |
MemoryCompactor CPU time – ratio per second (max. all hosts) |
% |
Yes |
|
HDB_THR_MC_CPUTH |
MemoryCompactor CPU time – ratio per second (per host) |
% |
Yes |
|
HDB_THR_MERGEDOG |
Maximum duration of mergedog threads |
S |
Yes |
|
HDB_THR_REPLICA |
Maximum runtime of replications |
S |
Yes |
|
HDB_THR_SQLEC1 |
Number of SqlExecutor threads (running for more than 1 minute) |
Number |
Yes |
|
HDB_THR_SQLERUN |
Number of running SqlExecutor threads (max. all hosts) |
Number |
Yes |
|
HDB_THR_SQLERUNH |
Number of running SqlExecutor threads per host |
Number |
Yes |
|
HDB_THR_SQLETTL |
Total number of SqlExecutor threads (max. all hosts) |
Number |
Yes |
|
HDB_THR_SQLETTLH |
Total number of SqlExecutor threads per host |
Number |
Yes |
|
HDB_THR_SQLRUN |
Maximum duration of SqlExecutor threads |
s |
Yes |
|
HDB_THR_TIME_CAP |
Runtime to capture threads |
ms |
Yes |
Parameters
The following parameters are used for this collector:
|
Parameter name |
Description |
Default value |
|---|---|---|
|
MAX_DURATION_FOR_HANGING_SQL |
This parameter affects the KPI HDB_THR_SQLEC1 and is set to 60000 milliseconds by default. It only reports threads into this KPI that have been running longer than defined value in this parameter in milliseconds. |
60000 |
|
SUPPRESS_NO_ACTION_THREADS |
By default, this parameter is set to X to suppress the reporting of threads with the method NoAction into the detail table HANA DB thread info. If this parameter disabled with the value <empty>, threads with the method NoAction are also reported into the detail table HANA DB thread info. |
X |
Detail Table
The collector provides the detail table HANA DB thread info. The technical name of the detail table is /DVD/MON_HDB_S_THREAD.
The detail table HANA DB thread info provides a lot of detail about threads. This information comes from the HANA view M_SERVICE_THREADS. It contains the following fields:
|
Technical name |
Description |
|---|---|
|
HOST |
Host name |
|
PORT |
Port |
|
SERVICE_NAME |
Service name. To view all the known service names, see M_SERVICE_TYPES. |
|
HIERARCHY |
Thread grouping information. This column contains the connection ID, the update transaction ID and the transaction ID. The column is empty if the threads are inactive. |
|
CONNECTION_ID |
Connection ID |
|
THREAD_ID |
Thread ID |
|
THREAD_TYPE |
Thread type |
|
THREAD_METHOD |
Thread method |
|
THREAD_DETAIL |
Thread detail |
|
THREAD_STATE |
Thread state |
|
IS_ACTIVE |
Specifies whether the thread is active |
|
DURATION |
Thread duration in milliseconds |
|
CALLER |
Service that called the thread |
|
CALLING |
Service that was called by the thread |
|
STATEMENT_ID |
ID of the statement being executed |
|
STATEMENT_HASH |
MD5 hash value for STATEMENT_STRING |
|
USER_NAME |
SQL username |
|
APPLICATION_NAME |
Application name |
|
APPLICATION_USER_NAME |
Application username |
|
APPLICATION_SOURCE |
Specifies that the application can define which source file SAP HANA is called from. This value is also displayed in the system view M_PREPARED_STATEMENTS.APPLICATION_SOURCE. |
|
CPU_TIME_SELF |
Active CPU time of the thread in microseconds |
|
CPU_TIME_CUMULATIVE |
Active CPU time of the thread and its associated children in microseconds |
|
CLIENT_IP |
IP of the client machine |
|
CLIENT_PID |
Client process ID |
|
STATEMENT_EXECUTION_ID |
Statement execution ID |
|
TRANSACTION_ID |
Transaction ID |
|
UPDATE_TRANSACTION_ID |
Update transaction ID |
|
LOCK_WAIT_COMPONENT |
Component assigned to the lock |
|
LOCK_WAIT_NAME |
Internal name of the lock. This name can be joined with the column STATISTICS_NAME from, for example, M_MUTEXES. |
|
LOCK_OWNER_THREAD_ID |
ID of the thread that is holding the lock. |
|
LOCKS_OWNED |
Locks currently owned by the thread, including the lock type (shared or exclusive). This column does not show all locks that are monitored. |
|
PRIORITY |
Statement priority |
|
PASSPORT_ACTION |
Passport action |
|
PASSPORT_COMPONENT_NAME |
Passport component name |
|
PASSPORT_CONNECTION_COUNTER |
Passport connection counter |
|
STATEMENT_MEMORY_LIMIT |
Statement memory limit |
|
STATEMENT_THREAD_LIMIT |
Statement thread limit |
