Archives of the TeradataForum
Message Posted: Thu, 25 Oct 2001 @ 19:25:34 GMT
| Subj: | | Re: Performance |
| |
| From: | | David Hough |
I use Teradata Manager to keep an eye on things, using Performance/DUC with the All Nodes CPU chart as my standard tool. An
unusually busy system will show up right away, as will an unbalanced load. Then I use PMON to find the most active users and see
what they are doing.
We also monitor hardware performance form the Unix side (from sar data) and product web charts of cpu, i/o and runq versus time.
This is a semi-standard type of monitoring done on all the Unix systems in our area. These charts are updated every 30 minutes, and
provide a more long term picture that TDM/PMON.
Occasionally we look at netstat data to check on network traffic or logonoff data to see where users are coming from (via the
embedded IP address). But these queries are usually run in response to other indicators.
/dave hough
|