Archives of the TeradataForum

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

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

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	Next>	Last>>