(DI-2308) Collector for HANA Thread Info

The technical name of this collector is /DVD/MON_HDB_CL_COL_THREAD.

This collector collects information about HANA threads, like details for active threads, 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

KPI name

Description

Unit

Detail table

HDB_THR_BACKUP

Max. duration of Backup threads

S

Yes

HDB_THR_COUNT

Number of active HANA threads

Count

Yes

HDB_THR_JOBWRUN

Thread JobWorker Running (max all hosts)

Count

Yes

HDB_THR_JOBWRUNH

Thread JobWorker Running per host

Count

Yes

HDB_THR_JOBWTTL

Thread JobWorker Total (max all hosts)

Count

Yes

HDB_THR_JOBWTTLH

Thread JobWorker Total per host

Count

Yes

HDB_THR_MAXRUN

Max. duration of HANA threads

S

Yes

HDB_THR_MC_CPUT

MemoryCompactor CPU Time - ratio per sec (max all host)

%

Yes

HDB_THR_MC_CPUTH

MemoryCompactor CPU Time (ratio per sec) per host

%

Yes

HDB_THR_MERGEDOG

Max. duration of MergeDog threads

S

Yes

HDB_THR_REPLICA

Maximum runtime of replications

S

Yes

HDB_THR_SQLEC1

Number of Thread SqlExecutor (running more than 1 minute)

Count

Yes

HDB_THR_SQLERUN

Number of running Thread SqlExecutor (max all hosts)

Count

Yes

HDB_THR_SQLERUNH

Number of running Thread SqlExecutor per host

Count

Yes

HDB_THR_SQLETTL

Total number of Thread SqlExecutor (max all hosts)

Count

Yes

HDB_THR_SQLETTLH

Total number of Thread SqlExecutor per host

Count

Yes

HDB_THR_SQLRUN

Max. 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

Parameter name

Description

Default value

MAX_DURATION_FOR_HANGING_SQL

This parameter affects the KPI HDB_THR_SQLEC1 and by default is set to 60000 (ms). It reports into this KPI only threads that are 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 method NoAction into detail table HANA DB Thread Info.

If this parameter disabled (set to empty value), also threads with method NoAction are reported into detail table HANA DB Thread Info.

X

Detail table

The collector provides a detailed table of HANA DB Thread Info. The technical name of this detail table is /DVD/MON_HDB_S_THREAD and it provides a lot of detail about threads. Information comes from HANA view M_SERVICE_THREADS.

Technical name

Description

Technical name

Description

HOST

Host name

PORT

Port

SERVICE_NAME

Service name. See M_SERVICE_TYPES for all known service names.

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 called by the thread

STATEMENT_ID

ID of the statement being executed

STATEMENT_HASH

MD5 hash value for STATEMENT_STRING

USER_NAME

SQL user name

APPLICATION_NAME

Name of application

APPLICATION_USER_NAME

Name of application user name

APPLICATION_SOURCE

Specifies that the application can define which source file SAP HANA is called from. This value is also displayed in the M_PREPARED_STATEMENTS.APPLICATION_SOURCE system view.

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 (can be joined with the STATISTICS_NAME column 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/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