Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 17 Mar 2003 @ 15:24:25 GMT


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


Subj:   Canary queries and SQL for performance monitoring
 
From:   Noe Gutierrez

Hi Teradata Community,

We are currently looking for a way to implement a "traffic light" in our web site that will show our users the current load on the Teradata box; so they can have an expectation on how long will take to their queries to run.

Currently we are querying DBC.ResGeneralInfoView with the following SQL:

SELECT AVG(CPUBusy/Secs) (FORMAT 'ZZ9', TITLE 'CPU Bsy %')
FROM DBC.ResGeneralInfoView
WHERE ( TheDate = current_date
AND TheTime >= (select max(thetime)
from DBC.ResGeneralInfoView where TheDate = current_date));

The issue comes as this SQL shows the physical CPU utilization, which will jump to 100% with only one user in the box, does anyone have a better understanding of which table/view do we need to query in order to get a better picture of the current activity in the box?


Thanks,

Noe Gutierrez
Sr. DWH Developer



     
  <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