Saturday, January 15, 2011

How can you determine I/O and CPU usage at a user level in Teradata?

How can you determine I/O and CPU usage at a user level in Teradata?
Answers:

You can find out I/O and CPU Usage from this Data Dictionary Table DBC.AMPUSAGE;

SELECT ACCOUNTNAME, USERNAME, SUM(CPUTIME) AS CPU, SUM(DISKIO) AS DISKIO FROM DBC.AMPUSAGE GROUP BY 1,2 ORDER BY 3 DESC;

No comments:

Post a Comment