Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 21 Jan 2003 @ 14:36:26 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: CPUTime in AmpUsage
From:   Belle, Patrick A


You need to keep in mind that the time recorded in AMPUSAGE for the interval expressed by your account string expansion is the (cpu) time required for the unit of work which began in that interval. More simply, if you started a query on a session at noon today, and the query ran for 4 (wall clock) hours, you'll have roughly 4 hours of time accounted for in your ampusage rows for that query alone. That'll make the ampusage for noon today look roughly like your're running at 400% of capacity!

I usually interpret these anomalies as meaning that work is "spilling over" into subsequent intervals and when this happens frequently, it often means that you've got a cpu bottleneck brewing that may need to be addressed.

Pat Belle
Teradata Certified Master

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