Skip to end of metadata
Go to start of metadata

HANA_Threads_ThreadSamples_FilterAndAggregation_Rev74+_ESS

Display history of running threads during a specified time. Can be used to determine what SQL statements were run during a specified time (IE times of high CPU usage)

Input Parameters

BEGIN_TIME
END_TIME
HOST
PORT
THREAD_ID
THREAD_TYPE
THREAD_STATE
THREAD_DETAIL
STATEMENT_HASH     
APP_NAME
APP_USER
APP_SOURCE
CLIENT_PID
CONN_ID
MIN_DURATION_MS
SQL_TEXT_LENGTH
EXCLUDE_SERVICE_THREAD_SAMPLER
AGGREGATE_BY
DURATION_AGGREGATION_TYPE
RESULT_ROWS
DATA_SOURCE

Output Parameters

MIN_SAMPLE_TIME:  Minimum timestamp of a sample
MAX_SAMPLE_TIME:  Maximum timestamp of a sample
NUM_SAMPLES:      Number of samples
PERCENT:          Percentage of samples compared to overall number of samples
ACT_THREADS:      Average number of active threads
SAMPLE_TIME:      Sample timestamp
HOST:             Host name
PORT:             Port
THREAD_ID:        Thread identifier
THREAD_TYPE:      Thread type
THREAD_METHOD:    Thread method
THREAD_STATE:     Thread state
THREAD_DETAIL:    Thread detail
DURATION_MS:      Duration (in ms), value is aggregated based on DURATION_AGGREGATION_TYPE
STATEMENT_HASH:   SQL statement hash value
CONN_ID:          Connection identifier
APP_NAME:         Application name
APP_USER:         Application user
APP_SOURCE:       Application source
CLIENT_PID:       Client process ID
LOCK_COMPONENT:   Lock component
LOCK_NAME:        Lock name
BLOCKING_THREAD:  Thread responsible for lock wait
SQL_TEXT:         SQL statement text (currently disabled)

  • No labels