I've noticed that the REQ CPU column doesnt reset or start over, if you say run another query right after another ?
If you wait a bit it clears and starts over....
Is this designed to be this way.... its mis-leading my customers... is there an option or something I overlooked...
The REQ CPU column in Viewpoint comes directly from the RequestAmpCPU field in the MONITOR SESSION API from the PM/API. This field is defined as "The total CPU usage by the current SQL request on the session on all AMPs.". Therefore, it should update any time there is a new request being executed on the session.
Note that session metrics returned from this API are only updated at the session sampling rate configured on your Teradata system.