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.
Captured metrics include:
CPU execution time – the time, in milliseconds, it takes to execute the query.
Elapsed time – the time, in milliseconds, from after the compile to the end of the execution.
Logical I/O – the number of logical I/O reads.
Physical I/O – the number of physical I/O 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, except count and abort count, has three values: minimum, maximum, and average.
