Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 14 Jul 2004 @ 15:40:58 GMT

  <Prev Next>   <<First <Prev

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

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