PROVE IT !!If you know it then PROVE IT !! Skill Proficiency Test

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

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;

Add a Comment

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