(DI-2305) Collector for HANA Thread Info
- SNP
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 |
|---|---|---|---|
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 |
|---|---|---|
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 |
|---|---|
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 |