Collector for HANA Thread Samples
The technical name of the Collector for HANA Thread Samples is /DVD/MON_HDB_CL_COL_THR_SAMPLE.
This collector collects various thread samples and their details.
Default KPIs Delivered with This Collector
The following default KPIs are delivered with this collector:
|
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 |
|---|---|---|
|
LIMIT_COUNT |
Affects the detail table HANA thread sample details. Only threads with COUNT_THREAD (number of times that the thread is reported) that is higher or equal to the value of this parameter will be reported to the 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 the detail table HANA thread sample details.
The detail table HANA thread sample details provides more details about thread samples. It contains the following fields:
|
Technical name |
Description |
|---|---|
|
USER_NAME |
SQL username |
|
APPLICATION_USER_NAME |
Application username |
|
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 depends on the application. |
|
COUNT_THREAD |
Number of times that the thread is reported |
|
STATEMENT_STRING |
SQL statement string |
