Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 23 Jan 2002 @ 14:27:35 GMT


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


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



     
  <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