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