Archives of the TeradataForum
Message Posted: Tue, 15 Dec 2015 @ 16:11:41 GMT
| Subj: || || Re: AvgCPUTime greater than MaxCPUTime |
| From: || || Anomy Anom |
<-- Anonymously Posted: Tuesday, December 15, 2015 11:45 -->
You probably have Summary logging for long-running queries.
The average is the sum of consumption recorded over the interval divided by the number of queries completed in that interval. Say you have 10
long-running queries and each consumes 1 second CPU over the summary interval, but only 1 of them completes. Then Max = 1 for any one query but
Avg would be reported as 10.