#DateWhereItemComment
19512 Nov 2012 @ 09:06 PSTcarrie's blogHow to set a System-Level CPU limit for Capacity-on-DemandVasu, Your question has already been answered on the Masters forum, with this comment: ======= Resusage will still show the same number of CPU seconds and will still show 100% CPU utilizat...
19409 Nov 2012 @ 01:49 PSTcarrie's blogUtility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED)No restart required. Here's what the documentation I have on that parameter states: 198. DisableTDWMSessionRules - This field disables TDWM session configuration rules which determine the num...
19309 Nov 2012 @ 01:33 PSTcarrie's blogUtility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED)Hi James, DisableTDWMSessionRules is an internal field in DBS Control. If you set it to TRUE then the pre-13.10 behavior will be preserved, and you can run TASM without the centralized session ...
19209 Nov 2012 @ 07:59 PSTcarrie's blogFlow Control and Spawned WorkI am not aware of any user-available alert mechanisms for bad disks. However, you can look at ResUsageSLDV (logical device detail), specifically at the LdvReadRespMax and LdvWriteRespMax and cross...
19108 Nov 2012 @ 02:00 PSTcarrie's blogReserving AMP Worker Tasks? Don’t let the Parameters Confuse You!If you increase total AWTs per AMP from 80 to 120, you will be adding 40 new AWTs per AMP. Those new AWTs will all go into the unassigned pool. The standard 8 reserve pools will still have 3 rese...
19007 Nov 2012 @ 10:38 PSTcarrie's blogFlow Control and Spawned WorkBeing in the state of flow control is difficult to pin on one query or even one small group of queries. It is a result of the system having more work presented to it than it can manage at that tim...
18907 Nov 2012 @ 10:33 PSTcarrie's blogIf You’re Not Collecting Statistics on Your Dictionary Tables, Do It. Now.The unhashed tables in the data dictionary contain AMP-local data. Either the rows are related to an activity on that AMP or there is a complete set of rows on each AMP. For example, the Tra...
18805 Nov 2012 @ 01:19 PSTcarrie's blogReserving AMP Worker Tasks? Don’t let the Parameters Confuse You!If you have 120 AMP worker tasks per AMP defined, you will still have the same limit of 20 on how many reserved AWTs you can define for that system. The reserve AWT setting is independent of the ...
18731 Oct 2012 @ 03:37 PDTcarrie's blogAre AMP Worker Tasks used by FastExport in Response Mode?Hi Shrinivas, The vertical and/or horizontal redistribution processes are done as part of the basic processing within FastExport. So they will use the same AMP worker task work types that stan...
18629 Oct 2012 @ 02:54 PDTcarrie's blogEnforcement Priority: Soft, Hard, or Just Window-Dressing?If you have two allocation groups in RP1 and each of them has a 20% CPU limit, and in addition RP1 itself has a 20% CPU limit, then the work of all of the allocation groups under RP1 will be limite...
18526 Oct 2012 @ 04:27 PDTcarrie's blogTwo Levels of Concurrency Control for Load Utilities in Teradata 13.10Brian, Yes, exactly. But at the workload throttle level you can target a subset of the load jobs of that type, which gives you significantly more control over who is getting how many of the uti...
18426 Oct 2012 @ 04:24 PDTcarrie's blogNew opportunities for statistics collection in Teradata 14.0I asked someone in my office to do the same thing you did in your comment (the same column order in both cases for two different stats collections) right after each other on a Teradata 14.0 system,...
18326 Oct 2012 @ 03:48 PDTcarrie's blogUtility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED)You can use query band value-pairs at either the transaction or the session level to help direct queries or utilities to specific workloads. However, you cannot specify in a query band alone that ...
18218 Oct 2012 @ 12:28 PDTcarrie's blogTeradata 13.10 Statistics Collection Recommendations There is no mechanism in 13.10 that would allow you to identify stats that are not being used by the optimizer. A future release of Teradata will be collecting that information because it has been...
18116 Oct 2012 @ 09:01 PDTcarrie's blogIntrepreting DBQL DelayTime in Teradata 13.10Shrinivas, I appreciate your input to Mark on his ODBC questions. Thanks, -Carrie
18015 Oct 2012 @ 04:20 PDTcarrie's blogIntrepreting DBQL DelayTime in Teradata 13.10Mark, Unfortunately, I am not familiar with client conventions and am not able to provide an answer to your question above concerning disabling ODBC parsing. If Shrinivas is not able to explai...
17915 Oct 2012 @ 04:18 PDTcarrie's blogIntrepreting DBQL DelayTime in Teradata 13.10Shrinivas, DelayTime will be reported as zero for any delay that is greater than zero but less than one second. DelayTime used to be reported in hundredths of a second in 12.0, but has been cha...
17815 Oct 2012 @ 10:48 PDTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Hi Andrew, Yes, that should be fine. For simple data type/char set conversions, the optimizer uses statistics from the underlying columns. Thanks, -Carrie
17712 Oct 2012 @ 08:29 PDTcarrie's blogIntrepreting DBQL DelayTime in Teradata 13.10Thanks Shrinivas! Excellent point. I'd check out Shrinivas's suggestion first, it sounds like a fit for what you describe. Another thing to be aware that there were some issues around DBQL rep...
17609 Oct 2012 @ 12:36 PDTcarrie's blogHow to Calculate Your Max Number of Usable AMP Worker TasksIf your question is about Viewpoint Alerts as documented in the Teradata Alerts manual, this alert considers available AWTs, not AWT saturation: Viewpoint will generate Alerts based on the ‘Av...
17504 Oct 2012 @ 02:49 PDTcarrie's blogAutomated Demotions on the Appliance: What are Query Milestones?A query is not allocated to a resource partition directly. It is mapped to a performance group. A query is under the control of an allocation group, based on which allocation group its performance ...
17404 Oct 2012 @ 11:31 PDTcarrie's blogEnforcement Priority: Soft, Hard, or Just Window-Dressing?A CPU limit placed on an RP (resource partition) will limit the CPU used by all the allocation groups active within the RP. A RP-level CPU limit will not be exceeded by the combined CPU usage of ...
17304 Oct 2012 @ 08:17 PDTcarrie's blogPenalty Box Over-Population You are very welcome. Thanks for taking time to let me know that it helped. - Carrie
17227 Sep 2012 @ 04:12 PDTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Response to abhishekjain25: Why don't you try posting your question on the Teradata Forum? Sorry, but it is not in my area of experience or expertise. Thanks, -Carrie
17127 Sep 2012 @ 04:11 PDTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Response to rayravi: There is an AutoStats feature that will be available in Teradata 14.10, which will support the automation of stats collection and also analysis for which stats to collect on...

Pages