 |
 |
Archives of the TeradataForum
Message Posted: Wed, 23 Jan 2002 @ 14:27:35 GMT
| Subj: | | Re: Magic Wand Question |
| |
| From: | | Geoffrey Rommel |
| | If you had a magic wand you could use to wave at a Teradata performance/performance analysis problem and could thus solve it, what
problem would you target and why? | |
This is not exactly performance analysis, but I would like a history of sessions. The EventLog table has history, but it's
inadequate; the SessionTbl tells you only about currently running sessions. I would like something that would retain the history of
sessions, including host number, session number, start timestamp, end timestamp, partition, logon sequence number, total CPU, total I/O's,
etc.
I would be particularly interested in knowing about every session that did a load to a table. This could be a little tricky, though. To
begin with, you could capture sessions that run in the FASTLOAD or MLOAD partition; Teradata could also provide an additional table that
would record the session-table relationship (session 123 performed a load on table abc.xyz). But how would you capture TPumps? And what
about insert/selects? Hmm.
--wgr
| |
