HP Integrity NonStop H-Series Uživatelská příručka stáhnout pdf (Strana 196)

HP NonStop Shadowbase Command Definitions

Consumer Command Descriptions

HP NonStop Shadowbase Command Reference Manual—785421-002

187

%RECV MWAIT shows the percentage of time that the CONS is waiting on an

AWAITIO to complete and a read is posted on $receive (RECV MWAIT

time divided by total time in the statistics interval).

BYTES RCVD shows the total number of bytes received from the collector.

BPS RCVD shows the average number of bytes per second received from the

collector.

SCHEMA INFO – This section shows information related to the schema.

HITS shows how often the Consumer found the schema it needed in

memory.

MISSES shows how many times it had to get the schema.

%HITS is the percentage of the time it hit.

INMEM shows how many schema are stored in memory.

RESERVED shows the amount of memory reserved for schema.

ALLOC shows how much of that space is currently allocated.

USED shows how much of the allocated space is in use.

FREE shows how much schema space is free.

SQL STATMENT INFO – This section shows information related to SQL

statement caching.

HITS show how many times an SQL statement was used from memory.

MISSES shows how often it had to formulate an SQL statement.

%HITS shows the percentage of the time it hit a SQL statement in memory.

INMEM indicates the number of SQL statements currently in memory.

AVG SRCH shows the average number of searches needed to find an SQL

statement.

%FR columns indicate the percentage of the needed SQL statements that

were found in the frequency range associated with the column (i.e.,i.e.,

%FR1 = 1

through 20

stored statements, %FR2 = 21

through 100

, %FR3 =

101

through 300

th,

%FR4 = more than 301

PREPARES shows the number of SQL statement compiles prepared by the

CONS. If this number is increasing, it may mean that statement cache

size is too small.

PREPARE TIME shows the amount of time the CONS has spent doing SQL

compiles.

%PREP shows the percentage of time the CONS has spent doing SQL

compiles during this statistics interval (normally will be very small).

AVG PREP shows the average SQL statement compile time computed by

dividing PREPARES into the PREPARE TIME.

TARG I/O shows the number of SQL I/O operations executed against the

target tables (i.e.,i.e., inserts, updates, and deletes).

I/O TIME shows the amount of time the CONS has spent executing SQL

statements against the target tables (for inserts, updates, and deletes).

This includes the time the Consumer is blocked, waiting for these I/O

operations to complete. If high, this could indicate that the file system is

1 2 ... 191 192 193 194 195 196 197 198 199 200 201 ... 345 346

Komentáře k této Příručce

Žádné komentáře

HP Integrity NonStop H-Series Uživatelská příručka Strana 196

Komentáře k této Příručce

Související produkty a manuály pro Software HP Integrity NonStop H-Series