Hp Neoview Release 2.4 Software Manual de usuario Pagina 106

  • Descarga
  • Añadir a mis manuales
  • Imprimir
  • Pagina
    / 128
  • Tabla de contenidos
  • MARCADORES
  • Valorado. / 5. Basado en revisión del cliente
Vista de pagina 105
Table C-6 ODBC_QUERY_STATS_V2 Fields (continued)
Source and NotesData TypeIncomplete QueriesComplete Queries
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_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)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.
106 Pre-R2.4 SP2 Query Statistics Views
Vista de pagina 105
1 2 ... 101 102 103 104 105 106 107 108 109 110 111 ... 127 128

Comentarios a estos manuales

Sin comentarios