Skip to end of metadata
Go to start of metadata

HANA_SQL_ExpensiveStatements

Displays the queries that exceed what has been defined. Can be used when experiencing performance issues.

Please note that expensive statement trace needs to be activated

For more information on the expensive statement trace:

http://help.sap.com/saphelp_hanaplatform/helpdata/en/5f/af04f17830464eacdb7938b383d2ab/content.htm

Input Parameters

BEGIN_TIME
END_TIME
SQL_PATTERN
APP_USER
SQL_TEXT_LENGTH
AGGREGATE_BY
RESULT_ROWS

Output Parameters

EXECUTIONS:       Number of executions
ELAPSED_MS:       Elapsed time (ms)
ELA_PER_EXEC_MS:  Elapsed time per execution (ms)
LOCK_PER_EXEC_MS: Lock wait time per execution (ms)
CPU_PER_EXEC_MS:  CPU time per execution (ms)
ROWS_PER_EXEC:    Rows returned per execution (ms)
LAST_START_TIME:  Last start time of SQL statement
APP_USER:         Application user name
SQL_TEXT:         SQL statement text

 

 

  • No labels