Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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:

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?


Noe Gutierrez
Sr. DWH Developer

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020