(DI-2211) Collector for HANA Thread Info
- SNP
This collector collects information about HANA threads. Information like active threads, duration of threads runtime of HANA replications, etc. The technical name of this collector is /DVD/MON_HDB_CL_COL_THREAD
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 | Number | Yes |
HDB_THR_JOBWRUN | Thread JobWorker Running (max all hosts) | Number | Yes |
HDB_THR_JOBWRUNH | Thread JobWorker Running per host | Number | Yes |
HDB_THR_JOBWTTL | Thread JobWorker Total (max all hosts) | Number | Yes |
HDB_THR_JOBWTTLH | Thread JobWorker Total per host | Number | 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) | Number | Yes |
HDB_THR_SQLERUN | Number of running Thread SqlExecutor (max all hosts) | Number | Yes |
HDB_THR_SQLERUNH | Number of running Thread SqlExecutor per host | Number | Yes |
HDB_THR_SQLETTL | Total number of Thread SqlExecutor (max all hosts) | Number | Yes |
HDB_THR_SQLETTLH | Total number of Thread SqlExecutor per host | Number | 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 | Default 60000 (ms), affects KPI HDB_THR_SQLEC1. Under this KPI reports only threads running longer than stated by this parameter. | 60000 |
Detail table
The collector provides a detailed table 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 |