9 | 03 Nov 2015 @ 02:42 PST | carrie's blog | How to Calculate Your Max Number of Usable AMP Worker Tasks | Carrie,
Is there any way to calculate AWT consumed by a user/session? If no, can we use any colums to find out the same?
Thanks,
Dinesh
|
8 | 22 Oct 2015 @ 12:41 PDT | carrie's blog | Statistics Collection Recommendations – Teradata 14.10, 15.0 and 15.10 | Carrie,
Can we run collect stats when a table is being insert/update or vice versa? Is there any performance issue occur? Does it impact users who accesses those table on above situation?
... |
7 | 03 Jun 2015 @ 08:49 PDT | Extensibility | The Heatmap Table Function is now available |
Hi jlee,
Good Info. We have already installed the UDF & views and we are trying to generate the data temperature by partition for a specific table over time as mentioned above... |
6 | 05 May 2015 @ 11:10 PDT | carrie's blog | Using the ResUsageSAWT table to Monitor AMP Worker Tasks | Carrie,
Thanks for your valuable information and help.
Thanks,
Dinesh
|
5 | 01 May 2015 @ 11:36 PDT | carrie's blog | Using the ResUsageSAWT table to Monitor AMP Worker Tasks | Carrie,
Thanks for the detailed explaination. What you said was right, output from 12.0 IS NOT in summary mode and the 14.10 output IS in summary mode and each node has 36 AMPs, after... |
4 | 28 Apr 2015 @ 11:40 PDT | carrie's blog | Using the ResUsageSAWT table to Monitor AMP Worker Tasks | Carrie,
Right now we have TD 14.10(6750) and we had TD 12(5550). Below is the output of DBC.ResUsageSAWT for TD 14.10
TheDate|VprId|Node Type|Active|InuseMax|Av... |
3 | 21 Apr 2015 @ 09:55 PDT | carrie's blog | Using the ResUsageSAWT table to Monitor AMP Worker Tasks | Carrie,
It seems WorkTypeInuse00, WorkTypeInuse01 vaules fromDBC.ResUsageSawt/PDCRINFO.ResUsageSAWT are returning wrong values. And the total awt count ... |
2 | 18 Dec 2014 @ 02:42 PST | Teradata Performance Considerations | Performance Data Collection Recommendations for Major Upgrades | Hi,
How can I see the history of database space using diskspace?
I want to see last month's database size of databases in the system using PDCR. Please shed some light on this.
... |
1 | 10 Dec 2013 @ 11:52 PST | carrie's blog | Easing Into Using the New AutoStats Feature | Hi Carrie,
What are the privileges(access rights) required to Collect Statistics on any table? We have TD 12 installed.
Grant statistics on <dbname> to <rolename>. i tried this, but... |