Archives of the TeradataForum
Message Posted: Thu, 03 Dec 2003 @ 22:17:20 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|