#DateWhereItemComment
903 Nov 2015 @ 02:42 PSTcarrie's blogHow to Calculate Your Max Number of Usable AMP Worker TasksCarrie, 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
822 Oct 2015 @ 12:41 PDTcarrie's blogStatistics Collection Recommendations – Teradata 14.10, 15.0 and 15.10Carrie,   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? ...
703 Jun 2015 @ 08:49 PDTExtensibilityThe 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...
605 May 2015 @ 11:10 PDTcarrie's blogUsing the ResUsageSAWT table to Monitor AMP Worker TasksCarrie,   Thanks for your valuable information and help.   Thanks, Dinesh
501 May 2015 @ 11:36 PDTcarrie's blogUsing the ResUsageSAWT table to Monitor AMP Worker TasksCarrie,   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...
428 Apr 2015 @ 11:40 PDTcarrie's blogUsing the ResUsageSAWT table to Monitor AMP Worker TasksCarrie,   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...
321 Apr 2015 @ 09:55 PDTcarrie's blogUsing the ResUsageSAWT table to Monitor AMP Worker TasksCarrie,   It seems WorkTypeInuse00, WorkTypeInuse01 vaules fromDBC.ResUsageSawt/PDCRINFO.ResUsageSAWT  are returning wrong values. And the total awt count ...
218 Dec 2014 @ 02:42 PSTTeradata Performance ConsiderationsPerformance Data Collection Recommendations for Major UpgradesHi,   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. ...
110 Dec 2013 @ 11:52 PSTcarrie's blogEasing Into Using the New AutoStats FeatureHi 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...