Hp Neoview Release 2.3 Software Bedienungsanleitung PDF herunterladen (Seite 65)

this example, an ODBC session that executed a single query saturated the system from

approximately 19:25:00 to 19:35:00 and then was inactive.

reset param

set param ?segment_id 1;

set param ?node_id 0;

set param ?pin 863;

show param;

select

segment_id,

node_id,

pin,

sample_date, sample_time

metric_type,

child_count,

child_system_busy_pct as sys_busy

from NEO.HP_METRICS.PROCESS_AGGR_LEVEL1_STATS_V1

where segment_id = ?segment_id

and node_id = ?node_id

and pin = ?pin

order by segment_id, node_id, pin, metric_type, sample_date, sample_time FOR READ UNCOMMITTED ACCESS;

SYS_BUSYCHILD_COUNTMETRIC_TYPESAMPLE_TIMESAMPLE_DATEPINNODE_IDSEGMENT_ID

99.1319MXESP06:30:00.0000002007–05–2986301

99.4719MXESP06:35:00.0000002007–05–2986301

35.9919MXESP06:50:00.0000002007–05–2986301

0.0019MXESP06:35:00.0000002007–05–2986301

0.0019MXESP07:00:00.0000002007–05–2986301

Count Completed Queries, According to Specified Criteria

The following queries all return the number of completed queries, but they break down the

number in different ways.

Completed Queries Executed on a System in the Last 24 Hours

SELECT DISTINCT(QUERY_START_DATE) AS START_DATE,

COUNT(*) AS NUM_OF_QUERIES,

MAX(QUERY_START_TIME) AS MAX_START_TIME,

MIN(QUERY_START_TIME) AS MIN_START_TIME

FROM NEO.HP_METRICS.ODBC_QUERY_STATS_V2

WHERE QUERY_START_DATETIME <= CURRENT

AND QUERY_START_DATETIME >= CURRENT - INTERVAL '1' DAY

AND STATEMENT_STATE = 'COMPLETE'

GROUP BY 1

FOR READ UNCOMMITTED ACCESS;

MIN_START_TIMEMAX_START_TIMENUM_OF_QUERIESSTART_DATE

08:51:0112:48:46.8797742432007–05–23

13:15:1418:44:05.390777492007–05–22

Completed Queries Executed on a System in the Previous Two Days

To count queries that executed from one midnight to the next, instead of within a 24 hour period

relative to the current time, the following query uses the Neoview DATE_TRUNC function in

the SQL WHERE clause.

SELECT DISTINCT(QUERY_START_DATE) AS START_DATE,

COUNT(*) AS NUM_OF_QUERIES,

MAX(QUERY_START_TIME) AS MAX_START_TIME,

MIN(QUERY_START_TIME) AS MIN_START_TIME

FROM NEO.HP_METRICS.ODBC_QUERY_STATS_V2

WHERE QUERY_START_DATETIME <= CURRENT

Count Completed Queries, According to Specified Criteria 65

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

Kommentare zu diesen Handbüchern

Keine Kommentare

Hp Neoview Release 2.3 Software Bedienungsanleitung Seite 65

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Software Hp Neoview Release 2.3 Software