Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 06 Jul 2004 @ 21:41:59 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Question on AWT in Queue for a Period of Time
From:   Ballinger, Carrie

Hi Siva,

I don't know if this is what you were looking for, but you could check it out and see. It does not reflect "AMP worker tasks in a queue", but rather processes (messages actually) that are waiting in a queue for an available AMP worker task. I think that perhaps that is what you meant.

If you go the ResUsage manual for V2R5.1, on page 7-13 two columns from the SVPR table are explained. SVPR provides detail at the vproc level.

MsgWorkQLenSum -- Total number of work requests waiting during each log interval.

MsgWorkQLenMax -- Max number of work requests waiting

What this information reflects is summarized data on the queue length for messages waiting for AMP worker tasks. It is the sum and the max during the recent measurement interval. It does not provide information as to how many AWTs were in use, or high water marks for AWT usage. Rather it addresses the length of queue, which would be significant if AWTs were all in use.

You will have to go directly to the base table to view these columns.

Thanks, --Carrie

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016