Archives of the TeradataForum

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

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

Ruth,

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