(DI-2305) Collector for HANA Thread Samples
- SNP
- Tomas Hnojcik
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 |
|---|---|---|---|
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) higher or equal that 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 detailed table HANA Thread sample details.
HANA Thread sample details provide more details about thread samples.
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 is up to the application. |
COUNT_THREAD | Times thread is reported |
STATEMENT_STRING | SQL Statement string |