I am new to Teradata, i am looking for some of the important queries which will provide me current and past system utilization.
Ex. want to know which user consumed max resources in last 12 hrs etc...
Is there any way to know this?
You can get all these info from dbc.dbqlogtbl .
do a sel * on this.
Can check for amp usage. Cpu usage columns. can see the dates and time of the query from starttime column and username column gives corresponding username
I think you can get from these tables: