Archives of the TeradataForum

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

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

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>>