Archives of the TeradataForum
Message Posted: Thu, 27 Jun 2002 @ 12:28:28 GMT
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.
|