Archives of the TeradataForum
Message Posted: Mon, 17 Mar 2003 @ 15:24:25 GMT
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 %')
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|