#DateWhereItemComment
9501 Dec 2011 @ 12:35 PSTcarrie's blogPenalty Box Over-Population Koeby, Check the Viewpoint User Guide chapter on Workload Designer. That should help you with where and how to define exceptions on workloads. Thanks, -Carrie
9411 Nov 2011 @ 08:24 PSTcarrie's blogHow to set a System-Level CPU limit for Capacity-on-DemandThis is a duplicate question that was also added as a comment on the utility session management blog entry. The response can be found there, at: http://developer.teradata.com/blog/carrie/2011/0...
9311 Nov 2011 @ 08:16 PSTcarrie's blogUtility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED)Please see my article posted here in Developer Exchange that discusses confidence levels. There is an entire section on confidence levels in join steps. Basically, most join steps will never...
9228 Oct 2011 @ 11:09 PDTcarrie's blogFastExport for Really Short Queries in Teradata 13.10Hi Jim, FastExport does indeed have a higher setup overhead than regular SQL. Given a choice, standard SQL is probably a better choice when returning few rows. But if you are caught in a sit...
9128 Oct 2011 @ 08:35 PDTcarrie's blogNumber of AMP Worker Tasks used by Archive UtilitySorry, but I don't have a good answer for that question, as it's out of my area of experience. As an alternative, try posting your question on the Teradata Forum or on one of the other sites ...
9028 Oct 2011 @ 08:28 PDTcarrie's blogUtility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED)Your point is a good one. Developement is considering refinements to this feature, and I will pass your comments along as input to that process. You make a good case for greater flexibility. ...
8924 Oct 2011 @ 04:21 PDTcarrie's blogFastExport for Really Short Queries in Teradata 13.10Hi Sravani, I’m not aware of any formula for calculating FastExport spool usage. My suggestion is to use the EXPLAIN to get spool estimates for the SELECT which may include intermediate spool...
8819 Oct 2011 @ 02:46 PDTcarrie's blogFastExport for Really Short Queries in Teradata 13.10Hi Vicks, Thank you for the kind words. I'm not entirely sure, but you may be talking about a feature in the older version of FastExport that allowed you to generate VARTEXT records format fi...
8728 Sep 2011 @ 07:52 PDTcarrie's blogTips on using Sampled StatsThere are two reasons you might want to collect stats on a unique index. 1. You have queries that use the unique index as a predicate with a range constraint. 2. Under some conditions, stat...
8628 Sep 2011 @ 07:38 PDTcarrie's blogUtility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED)Thanks, Neil!
8526 Sep 2011 @ 08:39 PDTcarrie's blogRequest Cache Hits & MissesYou always want to be concerned about memory if you are having any swapping at all. See Woody's blog on how to assess memory issues. That might provide some tips. If you're not experiencing any...
8426 Sep 2011 @ 08:32 PDTcarrie's blogTips on using Sampled StatsTeraAbe, Unfortunatey, I have not attempted what you are asking about, either with SQL or by other means. You could put your question out to some of the other Teradata forums and see what others ...
8323 Sep 2011 @ 09:07 PDTcarrie's blogTips on using Sampled StatsA.F. It may be that you are reading less-than-current documentation. It used to be (not sure which release, but I think this is likely to the case in 6.2, which you are on) that the database ...
8221 Sep 2011 @ 02:47 PDTcarrie's blogTips on using Sampled StatsMost of the work of collecting stats is done in parallel across all AMPs. However, parts of it are on a single AMP. For example, the histogram is built by a single AMP. That is the case for both...
8113 Sep 2011 @ 09:38 PDTcarrie's blogUtility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED) If the question you are asking is how many AMPs are used to access data using those indexes, the answer is: UPI and PI use one AMP, USI usually uses 2 AMPS, and NUSI uses all AMP. Please se...
8015 Jul 2011 @ 11:10 PDTDatabaseStatistics Collection Recommendations for Teradata 12Hello ilf. You only need to re-collect statistics at the table level, if what you want is for all previously-collected statistics to be refreshed. When you recollect at the table level, all cur...
7908 Jul 2011 @ 05:15 PDTcarrie's blogHow to set a System-Level CPU limit for Capacity-on-DemandUnfortunately, I am not familiar with the process that was used in your case. The best I can suggest is that you consult with your CS representative to answer that question. Thanks, -Carrie
7808 Jul 2011 @ 05:14 PDTcarrie's blogNumber of AMP Worker Tasks used by Archive UtilityPlease see the Teradata Database Design manual, Chapter 10 and Chapter 11, for detailed information on using indexes in the Teradata database. There is also a class offered by Teradata Educatio...
7708 Jul 2011 @ 05:13 PDTDatabaseStatistics Collection Recommendations for Teradata 12There is no way that I am aware of for determining which statistics are actually used by the optimizer when building a query plan. You have to use your best judgement on which statistics to collec...
7628 Jun 2011 @ 08:12 PDTcarrie's blogTips on using Sampled StatsHi Uma, When full statistics are collected, all rows in the table are read and are input to the stats collection process. When USING SAMPLE is specified, then only a percent of the table's rows...
7523 Jun 2011 @ 09:21 PDTcarrie's blogTwo Levels of Concurrency Control for Load Utilities in Teradata 13.10Hi Steve, The original utility throttles prior to Teradata 12.0 could not delay FastLoad jobs, they could only reject them, when the limit was reached. It was not until Teradata 12.0 that the a...
7420 Jun 2011 @ 02:08 PDTcarrie's blogNumber of AMP Worker Tasks used by Archive UtilityThe database part of Arcmain has always and continues to be under the contol of priority scheduler. There used to be an issue with TASM when it first became available, where Arcmain jobs did not ...
7314 Jun 2011 @ 08:36 PDTcarrie's blogNumber of AMP Worker Tasks used by Archive UtilityUnfortunately, I am not the right person to help you to debug archive performance. There are many factors involved when an archive is taking place, such as the distribution of AMPs (your system is...
7226 May 2011 @ 08:18 PDTcarrie's blogHow to Calculate Your Max Number of Usable AMP Worker TasksHello Rajni, There is no change with Linux in terms of how AMP worker tasks are being used or how counts are being collected. If you are using Teradata Manager VPROC report to get AMP worker ...
7117 May 2011 @ 08:32 PDTcarrie's blogTwo Levels of Concurrency Control for Load Utilities in Teradata 13.10Hi Andy, Even with these enhancements I would still tend towards assigning normal SQL jobs and utilities to different workloads. If they shared a workload throttle, utilities could easily bloc...

Pages