Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 27 Jul 2000 @ 20:49:15 GMT


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


Subj:   CPU/IO values
 
From:   Garcia Vior Eduardo

Hi, We need to know if the CPU or I/O usage is accumulative per session number for the Teradata Manager's utilities, so, if you run a query that consume 300 secs.CPU and later, in the same session, you run another that consume 200 secs.CPU, the CPU usage in Teradata Manager's Utilities for this session is 500 secs.CPU... I'm right?

The problem is, when I define an alert in the Alert Policity which abort sessions when reach the threshold, and the value of CPU or IO usage is not real, is the total session value, and not the amount of the current query. This is an error because is not the real consume of the query. There is a way to reset this value for each query in the same session, like the "$D$T" in the accountname?


Thanks.

Regards.



     
  <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: 15 Jun 2023