Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 03 Dec 2003 @ 22:17:20 GMT


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


Subj:   Re: Home grown performance reporting
 
From:   Harizanov, Ivan A

Terry,

I spent some time not longer ago to understand the ResUsage tables and wrote some SQL which it seems to be ok.

This is the SQL

sel
      TheDate
     ,Substr(TheTime,1,5)
     ,SUM(CPUIdle)
     ,SUM(CPUSysOh)
     ,SUM(CPUUServ)
     ,SUM(CPUUExec)
     ,SUM(FileAcqReads)
     ,SUM(FileWrites)
     ,SUM(FilePreReads)
from   DBC.ResUsagesPma
where TheDate =  DATE
group  by 1,2
order by 1,2;

You should dedicate some time to understand the meaning of each column, the best place to look is the Teradata RDBMS Performance Optimization manual.

Ivan



     
  <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: 23 Jun 2019