![]() |
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.
01 Jun 2016
,
|
![]() |
|
![]() |
Hi all,
05 Dec 2014
| 1 comment
,
|
![]() |
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?
26 Jun 2014
,
|
![]() |
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 ?
17 Jan 2014
,
|
![]() |
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.
01 Jan 2014
| 1 comment
,
|
![]() |
Hi everyone,
23 May 2012
,
|
![]() |
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.
29 Jul 2010
| 8 comments
,
|
![]() |
Does the column AwtInUseMax from ResUsageSpma provide aggregated value for all the AMPs in the Node?
In ResUsageSpma data is reported per node. The definition of column AwtInUseMax is given as: Peak number of AWTs (Max) on this node. This We don't know if this gives us the maximum AWT count from all the AMPs in the node
18 May 2010
| 1 comment
,
|
![]() |
Under Construction.
28 Oct 2009
| 11 comments
,
|
![]() |
In ResUsageSpma and ResUsageSvpr tables our Teradata 13 installation (on SUSE) shows NodeType as UNKNOWN.
23 Jul 2009
| 1 comment
,
|
![]() |
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.
03 Apr 2009
| 18 comments
,
|