 |
 |
Archives of the TeradataForum
Message Posted: Wed, 04 Aug 2004 @ 19:37:43 GMT
| Subj: | | Re: Monitoring System CPU |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Wednesday, August 04, 2004 15:35 -->
| | Can anyone advise on the best way to monitor CPU usage throughout the day? (E.g. one thing >we would like to do is identify 'Highs and
Lows' during the day - so that we can move some of our scheduled jobs which require more resources to run at quieter times on the box). | |
You can run the macro dbc.resCPUbyNode, which will report CPU utilization at whatever interval you have resUsage logging set to. Exec
dbc.resCPUbyNode('FromDate', 'ToDate', 'FromTime', 'ToTime', 'FromNode', 'ToN ode') -> exec dbc.resCPUByNode('2004-08-04','2004-08-
04','00:00:00','23:59:59','000-00','999-99') for example. There are also other resCPU macros.byAMP, byGROUP etc.
NCR also probably has sar set up writing to a file every 20 minutes during the day / 1 hr at night as well. Look in /var/adm/sa. Sar -f
sa<date> to view.
| |
