HP Neoview Release 2.3 Software - Manual (Page 64)

Value Field
"SQL_CUR_26680060 " "STATEMENT_ID"
"SQL_SELECT-NON_UNIQUE" "STATEMENT_TYPE"
"INCOMPLETE" "STATEMENT_STATE"
"N" "QUERY_TEXT_IS_MULTIROW"
“” "ERROR_CODE"
0 "SEQUENCE_NUM"
0 “SEQUENCE_SIZE”
2007-05-23 22:30:05.867082 "QUERY_START_DATETIME"
2007-05-23 "QUERY_START_DATE"
22:30:05 "QUERY_START_TIME"
2007-05-24 05:30:05.867610 "QUERY_START_DATETIME_UTC"
2007-05-24 "QUERY_START_DATE_UTC"
05:30:05 "QUERY_START_TIME_UTC"
NULL "QUERY_END_DATETIME"
NULL "QUERY_END_DATE"
NULL "QUERY_END_TIME"
NULL "QUERY_END_DATETIME_UTC"
NULL "QUERY_END_DATE_UTC"
NULL "QUERY_END_TIME_UTC"
NULL "EST_COST"
NULL "QUERY_ELAPSED_TIME"
NULL "MASTER_EXEC_EXECUTION_TIME"
NULL "DISK_READS"
NULL "LOCK_ESCALATIONS"
NULL "LOCK_WAITS"
NULL "MESSAGE_BYTES_TO_DISK"
NULL "MESSAGES_TO_DISK"
NULL "ROWS_ACCESSED"
NULL "ROWS_RETRIEVED"
NULL "NUM_ROWS_IUD"
NULL "TOTAL_EXECUTES"
"select AVG(CPU) CPU, AVG(MEMORY) MEMORY,…" "SQL_TEXT"
List System Utilization for a Process
This query retrieves information about system utilization for a particular process (or set of
processes). Usually, the process in question is a particular NDCS server (i.e. an ODBC session).
The result set represents CPU utilization for that server and for its child executor processes.
Results are aggregated for 5 minute intervals. The results are ordered in chronological order. In
64 Examples and Guidelines for Creating Repository Queries