Archives of the TeradataForum

Message Posted: Tue, 05 Apr 2005 @ 23:46:50 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

The DBQL StartTime is when the parser first sees the query. If you have workload limits (throttles in V2R6) in place, and if a query were to be delayed, that delay happens at the dispatcher level, downstream from the parser. A delay would cause what you are labeling as DBMS_time to include the time the query was waiting in the delay queue.

If you want to eliminate potential delay time, DBMS time could be expressed as FirstRespTime - FirstStepTime.

The FirstStepTime is the moment when the dispatcher sends the message for the first step to the AMP(s).

Thanks, -Carrie

	<Prev	Next>		<<First	<Prev	Next>	Last>>