Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 22 Dec 2015 @ 07:28:34 GMT


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


Subj:   CPU & IO by workload
 
From:   Martin Barrow

Hi,

Does anyone have a query that will show CPU & I/O consumption by workload? We can't use DBQL as we don't have full logging on batch workloads.

The aim is to show of the resource being consumed, what the breakdown was across the TDWM workloads. The Ampusage could give a partial picture, but is no good where a workload is allocated not only on profile/accountstring, but on the expected query performance.

Can dbc.ResUsageSps be used for this purpose or even PDCRINFO.TDWMSummaryLog_Hst?


Thanks,

Martin



     
  <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