Query processing (QP) metrics identify and compare empirical metric values in query execution. When a query is executed, it is associated with a set of defined metrics that are the basis for comparison in QP metrics.
The metrics captured include:
CPU execution time – the time, in milliseconds, it takes to execute the query.
Elapsed time – the difference in milliseconds between the time the command started and the current time, as taken from the operating system clock.
Logical IO (LIO) reads – the number od Logical IO reads.
Physical IO (PIO) reads – the number of Physical IO reads.
Count – the number of times a query is executed.
Abort count – the number of times a query is aborted by the resource governor due to a resource limit being exceeded.
Each metric has three values: minimum, maximum, and average. Count and abort count are not included.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
