Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 07 May 2003 @ 15:58:47 GMT


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


Subj:   Re: CPU in Real-Time
 
From:   Geoffrey Rommel

  How we can get the Average CPU in real time through SQL.  



For session-level data, DBC.Acctg is updated in real time, but it may not have the detail you want.

Acctg will contain 1 row per AccountName and Vproc, so the detail available depends on how your account strings are set up. For instance, &I will generate a new account name for each SQL request, but &S will generate only one per session. Here's a summary by AccountName:

sel accountname, sum(cpu),sum(io),
avg(cpu), avg(io),
avg(cpu)/(max(cpu)+0.001) * 100 as cpu_eff, /* efficiency */
avg(io)/(max(io)+0.001) * 100 as io_eff
from dbc.acctg
group by 1
order by 1;



     
  <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