Hp Neoview Release 2.3 Software Manual do Utilizador descarregar pdf (Página 27)

Table 3-3 ODBC_QUERY_STATS_V2 Fields (continued)

Source and NotesData TypeIncomplete QueriesComplete Queries

END, or NULL for

an incomplete query

TIMEQUERY_START_TIMEQUERY_END_TIME

END, or NULL for

an incomplete query

TIMESTAMPQUERY_START_DATETIME_UTCQUERY_END_DATETIME_UTC

END, or NULL for

an incomplete query

DATEQUERY_START_DATE_UTCQUERY_END_DATE_UTC

END, or NULL for

an incomplete query

TIMEQUERY_START_TIME_UTCQUERY_END_TIME_UTC

START, else END,

else NULL

DOUBLE

PRECISION

EST_COST

END, or NULL for

an incomplete query

LARGEINTQUERY_ELAPSED_TIME

END, or NULL for

an incomplete query

LARGEINTMASTER_EXEC_EXECUTION_TIME

END, or NULL for

an incomplete query

LARGEINTDISK_READS

END, or NULL for

an incomplete query

LARGEINTLOCK_ESCALATIONS

END, or NULL for

an incomplete query

LARGEINTLOCK_WAITS

END, or NULL for

an incomplete query

LARGEINTMESSAGE_BYTES_TO_DISK

END, or NULL for

an incomplete query

LARGEINTMESSAGES_TO_DISK

END, or NULL for

an incomplete query

LARGEINTROWS_ACCESSED

END, or NULL for

an incomplete query

LARGEINTROWS_RETRIEVED

END, or NULL for

an incomplete query

LARGEINTNUM_ROWS_IUD

END, or NULL for

an incomplete query

LARGEINTTOTAL_EXECUTES

STARTVARCHAR(3200)

or NCHAR

VARYING(3200)

SQL_TEXT

NOTE: In both ODBC_QUERY_STATS_V1 and ODBC_QUERY_STATS_V2, the QUERY_ID

field contains the unique ID of the query unless an error occurs before the query is launched. In

this case, no query ID is assigned, and the corresponding field is populated with the value

<EMPTY>. The rest of the information pertaining to the query, including the error code, is stored

in the appropriate columns.

VIEW NEO.HP_METRICS.QUERY_RUNTIME_STATS_V1

This view provides information collected while a query is running. The Repository obtains this

information through a statistics gathering process within the Neoview Management Dashboard.

Because statistics are updated as the query executes, you can use this view to monitor running

queries.

Query Statistics 27

1 2 ... 22 23 24 25 26 27 28 29 30 31 32 ... 73 74

Comentários a estes Manuais

Sem comentários

Hp Neoview Release 2.3 Software Manual do Utilizador Página 27

Comentários a estes Manuais

Manuais e produtos relacionados com Software Hp Neoview Release 2.3 Software