Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 27 Jun 2002 @ 12:28:28 GMT


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


Subj:   PMON
 
From:   Paul Johnson

We have recently upgraded to V2R4.1.1 and PMON version 5.0.1. There are some nice new features in PMON such as viewing SQL and even an EXPLAIN report.

The skewing figures seem a bit odd though. The maximum skew appears to be limited to 98%. It is no longer calculated as the largest deviation from the average, like table skewing. It appears to be derived from the 3 highest and 3 lowest values compared to the average, which really doesn't paint the true picture as it's the single extreme value that determines the true skew extent.

Also, we were hoping that the combination of V2R4.1.1 and PMON 5.0.1 would give more insight into the CPU and IO usage by AMP for a single session. Double-clicking on 'CPU Skew' or 'Disk Skew' in the 'User Info' screen appears to generate the same graph no matter which session is selected. This would suggest that the figures being graphed are totals for the AMP and not specific to the session, which would be very useful indeed.

Paul Johnson.



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