Archives of the TeradataForum

Message Posted: Thu, 03 Dec 2003 @ 22:17:20 GMT

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

Terry,

I spent some time not longer ago to understand the ResUsage tables and wrote some SQL which it seems to be ok.

This is the SQL

sel
      TheDate
     ,Substr(TheTime,1,5)
     ,SUM(CPUIdle)
     ,SUM(CPUSysOh)
     ,SUM(CPUUServ)
     ,SUM(CPUUExec)
     ,SUM(FileAcqReads)
     ,SUM(FileWrites)
     ,SUM(FilePreReads)
from   DBC.ResUsagesPma
where TheDate =  DATE
group  by 1,2
order by 1,2;

You should dedicate some time to understand the meaning of each column, the best place to look is the Teradata RDBMS Performance Optimization manual.

Ivan

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