Archives of the TeradataForum
Message Posted: Wed, 14 Jul 2004 @ 15:40:58 GMT
| Subj: | | Re: Teradata Performance Monitor Object - API |
| |
| From: | | Dempsey, Mike |
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.
Mike Dempsey
Teradata Client Tools
| 
