(DI-2208) Collector for HANA Thread Samples

This collector collects several thread samples and their details. The technical name of this collector is /DVD/MON_HDB_CL_COL_THR_SAMPLE.

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_SAMPLE

Number of HANA Thread samples

Number

Yes

Parameters

The following parameters are used for this collector:

Parameter name

Description

Default value

Parameter name

Description

Default value

LIMIT_COUNT

Affects the detail table. Only thread relevant count higher than this parameter will be reported to detail table.

50

SELECT_TOP

Affects the detail table. Defines the maximum number of threads that will be reported to the detail table.

20

Detail table

The collector provides detailed table HANA Thread sample details.
HANA Thread sample details provide more details about thread samples.

Technical name

Description

Technical name

Description

USER_NAME

SQL user name

APPLICATION_USER_NAME

Application user name

THREAD_DETAIL

Thread detail (truncated)

STATEMENT_HASH

Unique identifier for an SQL string

PASSPORT_ACTION

Passport action

APPLICATION_SOURCE

Specifies that the application can define which source file SAP HANA is called from. The usage is up to the application.

COUNT_THREAD

Times thread is reported

STATEMENT_STRING

SQL Statement string