Hp Neoview Release 2.3 Software Uživatelský manuál stáhnout pdf (Strana 64)

ValueField

"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

1 2 ... 59 60 61 62 63 64 65 66 67 68 69 ... 73 74

Žádné komentáře

Hp Neoview Release 2.3 Software Uživatelský manuál Strana 64