Archives of the TeradataForum

Message Posted: Wed, 14 Feb 2007 @ 20:34:52 GMT

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

<-- Anonymously Posted: Wednesday, February 14, 2007 14:48 -->

Where to start... They are fundamentally different in so many ways.

AMPUsage is a CUMULATIVE accounting table. An AMP updates the accounting totals for the corresponding VPROC/User/Account combination when it finishes processing a step. If you are using Account String Expansion (and from the wording of your question you expect that to be the case) the expansion is done only at the start of each request and not changed for each step, even if it contains time components.

LogSchmonSystem is a collection of point-in-time snapshots of Priority Scheduler data, taken by the Teradata Manager service and inserted into the database. The CPU figures in this table represent AVERAGE consumption over the immediately preceding "age period".

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