Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 25 May 2004 @ 14:32:06 GMT


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


Subj:   Re: CPUUsage Per User
 
From:   Glen Blood

I've gotten good results with account string expansion (&S&D&T).

The &D&T will give you the Date time of the last request to the second. You have to parse the string. We have a nightly process that parses the strings to make querying easier. You then have to make an assumption that all processing takes place during the time period that the query starts. You then sum cpouseconds and divide by the period. I have gotten pretty good results when I look at hour time periods. There are always some outliers (really long queries). I usually graph this information against the resusage. That helps identify the period outliers.


Glen



     
  <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