Archives of the TeradataForum
Message Posted: Wed, 14 Jul 2004 @ 15:40:58 GMT
It appears that you are using the Teradata Performance Monitor Object (COM object) rather than the PM API.
Detailed descriptions of the data values are available in the "Teradata PM/API Reference" manual, but the field names will not be exact matches for the object properties. (I tried to use more meaningful names in the COM object.) However, in most cases you should have no problem matching the 2 sets of names.
The item you are refering to - AMPWorkerUse (or 'PercntAMPWT' in the PM/API manual) - shows the percentage of CPU time used by the Amp Worker Tasks. Due to 'normalization' it can exceed 100% if processing is skewed onto certain AMPs. In an idea system running completely parallel it would be at 100% when all the CPUs were at 100%... ignoring overheads etc.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|