#DateWhereItemComment
22023 Jan 2013 @ 03:54 PSTcarrie's blogHow to Calculate Your Max Number of Usable AMP Worker TasksResponse 1: 62 is the number of AWTs that will be available to support user work if you have the default number of 80 AWTs per AMP. I think that is what you were trying to say, but I wanted to cl...
21922 Jan 2013 @ 08:30 PSTcarrie's blogAutomated Demotions on the Appliance: What are Query Milestones?Hi Ruth, I am assuming you are talking about an Appliance platform. On the Appliance you can issue a SET SESSION ACCOUNT to change the priority of a running query. It is one of the monitor co...
21821 Jan 2013 @ 01:40 PSTcarrie's blogTeradata 13.10 Statistics Collection Recommendations You do not need to collect PARTITION stats on small tables that do not undergo growth, such as most dimension tables. You are correct that PARTITION stats are most important on large tables that d...
21721 Jan 2013 @ 01:37 PSTcarrie's blogCPU Limits at Multiple LevelsWhat resource usage levels can be supported on the platform while good tactical performance is also exhibited is very specific to the hardware power and balance, the nature of the tactical applicat...
21616 Jan 2013 @ 08:19 PSTcarrie's blogCPU Limits at Multiple LevelsTrustngs, In regards to CPU limits, you would not want to apply a CPU limit on an allocation group or a resource partition where a tactical query application runs, if that CPU limit is set lower...
21516 Jan 2013 @ 08:19 PSTcarrie's blogCPU Limits at Multiple LevelsA belated response to bpmurray: I'm so sorry, but I somehow missed this comment from quite a while back. Relative weight is an indication of what priority scheduler will allocate to an alloca...
21416 Jan 2013 @ 08:12 PSTcarrie's blogYet ANOTHER List…Post-Expansion Workload Management ChecklistGeeta, The above posting was assuming a change in hardware processing power, not a change in PM COD. For that reason you cannot apply this checklist directly to PM COD changes. Although i...
21310 Jan 2013 @ 08:27 PSTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Hi Velu, In Teradata 14.0 the HELP STATISTICS statement will no longer accept column or index specification. You will want to use the new SHOW STATISTICS command with the VALUES option to view ...
21209 Jan 2013 @ 10:56 PSTcarrie's blogPenalty Box Over-Population Whether or not you want to define a penalty box workload is completely up to you. Most sites that use a penalty box do not have to spend too much much time preventing it from becoming over-popula...
21109 Jan 2013 @ 10:52 PSTcarrie's blogHow to set a System-Level CPU limit for Capacity-on-DemandHi Mark, The SpareTmon00 column in the ResUsageSPMA table is actually named CODFactor in 14.0. It does indeed carry the COD percent, but only for platform metering COD, not for priority schedu...
21004 Jan 2013 @ 08:52 PSTcarrie's blogFlow Control and Spawned WorkPietro, DBS Control has an internal field MaxAMPWorkerTasks (internal field #4) that tells you the number of AWTs allocated to each AMP for that platform. The contents of internal DBS Control ...
20903 Jan 2013 @ 08:06 PSTcarrie's blogSimplifying AMP Worker Task Monitoring and Getting it RightGanapathy, The ResUsageSAWT table is primarily useful for assessing AMP worker task metrics by AMP. It provides AWT in-use counts and maximum in-use counts across the logging interval by work t...
20819 Dec 2012 @ 03:39 PSTcarrie's blogFlow Control and Spawned WorkHello C.Y. There is no way that I know of to identify if an individual query was delayed waiting to get an AWT. You can, however, see whether requests within a workload were delayed waiting for...
20713 Dec 2012 @ 02:51 PSTcarrie's blogControlling the Flow of Work in TeradataHi Mike, In Viewpoint, I've only ever used the Metrics Analysis portlet and the Capacity Heatmap for viewing AWT levels. I am not familiar with any reports being generated from Viewpoint. Tr...
20613 Dec 2012 @ 02:46 PSTcarrie's blogFlow Control and Spawned WorkPietro, Max number of AWTs per AMP as of 13.0 is 500, although we never advise anyone to go much above 110 or 120 today. It's there for the future. Prior to 13.0 is was 120. The Max fields ...
20513 Dec 2012 @ 02:45 PSTDatabaseStatistics Collection Recommendations for Teradata 12The only time I have seen a situation where a statistics does not help a query plan, but actually results in a worse query plan, is if the length of the statistic exceeds 16 bytes, and the leading ...
20430 Nov 2012 @ 08:24 PSTcarrie's blogDatabase Tasks that Run on the Parsing Engine Suman, The Access Count functionality was designed to provide exactly the information you are asking for. If you choose not to use it, the only alternative I can think of is to start collecting...
20330 Nov 2012 @ 08:22 PSTcarrie's blogDatabase Tasks that Run on the Parsing Engine Abhijit, The ResUsageSAWT table does not contain anything about parsing engine tasks, as its focus is AMP worker tasks exclusively. The SPS table does produce information about priority sche...
20227 Nov 2012 @ 10:41 PSTcarrie's blogUtility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED)Mark, If you are using MLoad 14.00.00.06, that erroneous utility count for MultiLoad could be due to a known TTU problem which has been fixed in MLoad14.00.00.07. Even without the fix, the coun...
20127 Nov 2012 @ 10:36 PSTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Table level recollections of stats in Teradata 14.0 will remember the USING options at each statistics level and apply them at recollection time. To continue to use the same USING options, do not...
20026 Nov 2012 @ 09:52 PSTcarrie's blogUtility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED)Hi Mark, The best way to determine the number of load utilities active at any point in time using the workload management APIs. Workload Management API consists of interfaces to PM/APIs and ope...
19926 Nov 2012 @ 08:38 PSTcarrie's blogTips on using Sampled StatsY.C. The default for USING SAMPLE is 2%, it can be modified globally using a dbscontrol field, but it's one of the internal parameters, as you have noticed. Internal settings are designed to be...
19826 Nov 2012 @ 08:32 PSTDatabaseStatistics Collection Recommendations for Teradata 12Hi Sanji, Indexes can be dropped on single column stats and the statistics will remain and will be valid and usable. Collecting statistics on an INDEX versus the COLUMN that makes up the in...
19723 Nov 2012 @ 03:36 PSTcarrie's blogControlling the Flow of Work in TeradataGeetha, Yes, you can define alert thresholds differently for different systems. Viewpoint will handle that. But I think your question is what threshold to use for different systems. First, ...
19613 Nov 2012 @ 12:54 PSTcarrie's blogChanges to the TASM AMP Worker Task Event in Teradata 13.10Mike, Thank you so very much for the thoughtful comments. Glad the posting helped. -Carrie

Pages