Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 31 Aug 2009 @ 22:02:00 GMT


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


Subj:   Reporting Performance by User or Group
 
From:   Watry, Mike

I am currently reviewing some server performance issues of our Teradata Server and am trying to identify the groups utilizing the Database during this time. Essentially I have three main groups that source or target the Teradata Server. I want to be able to show management the usage of each group during peak times. I am using the qrylog table to sum the CPU time and I\O.

Here is the query that I am using today. Do these metrics have any meaning? Is there a better way to achieve a usage report by user or group?

     select  Username, AcctStringDate, ownername, RoleName, ProfileName, extract (hour from
     CollectTimeSTamp), sum(ElapsedTime), sum(totalIOCount), sum(AMPCPUTIME) from DBC.qrylog
     QL join dbc.dbase DB on DB.Databasename = QL.username where collecttimestamp >
     '2009-07-20 00:00:47.43'
     group by 1,2,3,4,5,6

Thanks,

Mike



     
  <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