0 - 12 of 12 tags for resusage

We have many queries running at the same time exporting large amounts of data. The queires are being issued from a tool and are using ODBC ao TPT EXPORT is not an option. Is there a way using resusage data to measure export volume and determine if we are maxing out the export bandwith and if so where is the bottleneck occurring.


Hi all,
We're looking at reporting on CPU usage and trying to understand the difference between the CPU metrics in each table. We have PDCR to archive the acctg table in hourly and daily blocks.

For a given time period, I find that FileSCiAcqKB and FileSciDyRRelKB are both much larger than the sum of FileSDbAcqKB and FileSDBPresKB. Why would there be more IO reported to CylinderIndices than DataBlocks?

Is there any way of measuring what percentage of the resources are currently being used by top consuming queries ? For example, assuming currently a query can get 100% of the resources...how do I find the top consuming SQL queries using? 50%, 75% , etc ?
Currently on TD13.10

Hi, I have put together a dashboard showing all the AMPCPUTime consumed by our various workloads based on the data from the DBQL LOG table column, AMPCPUTime. I want to add the Idle time into this so that management get an accurate picture of what is going on the system.

Hi everyone,
I have a problem with the virtual machine (vmware) demo of TD Database that was working good until yesterday...
For my purposes I need the ResUsage tables to collect data and while making experiments changing in CTL the Logging Rate from 60 to 600 seconds the tables stop collecting rows.
I restart the virtual machine lots of time but nothing seems to happen, every enabled ResUsage table does not collect data anymore!!!

This is just a quick note to put some information out here to see if it helps you to more easily create charts from the Resusage data.

Much of the information you should be tracking comes from DBC.ResUsageSPMA, and that is what this process is going to analyze. Note that this process is for TD12 only.

In ResUsageSpma data is reported per node. The definition of column AwtInUseMax is given as:

Peak number of AWTs (Max) on this node. This
is not the Peak or the Max value stored in the
Priority Scheduler (sch) data structure and
reported by the puma utility. The sch peak value
is the Max value since startup is never set and
Max is the maximum allowed value.

We don't know if this gives us the maximum AWT count from all the AMPs in the node
sum of maximum AWT count from all AMPs

In ResUsageSpma and ResUsageSvpr tables our Teradata 13 installation (on SUSE) shows NodeType as UNKNOWN.
Did we miss anything during installation? can we define nodetype ourselves?
As per my understanding, NodeType should be automatically configured by Teradata.

NOTE:  This content is only relevant to sites on Teradata 12 or earlier.

Congratulations, you’re on Teradata 12! Now it’s time to start redefining your AMP worker task (AWT) monitoring procedures by making use of the new ResUsageSAWT table.