Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Fetch Time from DBQL
From:   Ballinger, Carrie

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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020