Cloud Computing

9) 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;

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *