#DateWhereItemComment
29522 Jul 2013 @ 09:38 PDTcarrie's blogStatistics collection recommendations – Teradata 14.0In Teradata 12.0 you can collect stats on base table columns/indexes, and also you can collect statistics on GTTs.  But with GTTs you can only collect single-column and index statistics.&...
29419 Jul 2013 @ 08:37 PDTcarrie's blogStatistics collection recommendations – Teradata 14.0I am unable to understand exactly what you are asking.  Teradata certainly allows you to insert data into a table you have defined.  It also allows you to collect statistics on columns of...
29311 Jul 2013 @ 10:13 PDTcarrie's blogTeradata 13.10 Statistics Collection Recommendations Based on what you say, when stats were collected on Sunday (day 07), there are no rows in the partition for day 06 and no rows in the partition for day 07 and no rows yet in the partition for day 0...
29208 Jul 2013 @ 11:18 PDTcarrie's blogCPU Limits at Multiple LevelsSorry, but I don't see any reference to "% of system" in the above blog posting I wrote, so I am not exactly sure I am understanding your question.   Do you mean priority sched...
29108 Jul 2013 @ 11:15 PDTDatabaseAll-AMP Random AMP Sampling? Sure, Why Not!Yes, you can see whether all AMP random AMP sampling or single AMP random AMP sampling is going to be close to the same by comparing them both.   All AMP sampling can only be turned on&nb...
29025 Jun 2013 @ 01:11 PDTcarrie's blogStatistics collection recommendations – Teradata 14.0Collecting statistics on an INDEX versus the COLUMN that make up the index is just a syntax difference today.  The collection and storage of the stats information is the same, and the impact o...
28924 Jun 2013 @ 08:54 PDTcarrie's blogTASM State Changes are Streamlined in Teradata 14.0The DBA has to activate the rule set he wants to be the active one.  This is done within the Viewpoint Workload Designer portlet.   Each rule set had a config ID number. &n...
28824 Jun 2013 @ 08:52 PDTcarrie's blogTeradata 13.10 Statistics Collection Recommendations Hi Mark,   All-AMP sampling is set in DBS Control.   It is Internal Field #65:      65.  RandomAmpSampling      = D   RandomAm...
28720 Jun 2013 @ 08:06 PDTcarrie's blogRecommended Dictionary Statistics to Collect in Teradata 14.0  Sorry, but I don't have such a query, but it's likely someone out there does.   It would be best to post this kind of question on Teradata Forum, where you can reach a much b...
28619 Jun 2013 @ 03:43 PDTcarrie's blogRecommended Dictionary Statistics to Collect in Teradata 14.0Statistics collection on the DBC tables is important because those tables are being used by third party tools with complex SQL (X-views) and the queries are often taking a long time.  Those 3r...
28514 Jun 2013 @ 08:53 PDTcarrie's blogIntrepreting DBQL DelayTime in Teradata 13.10Hi JoAnne,   Yes, you can subtract FirstStepTime from StartTime and that will include delay time.  We used to do that before V2R6 in order to capture the impact of throttle delays on re...
28414 Jun 2013 @ 08:43 PDTcarrie's blogHow to Calculate Your Max Number of Usable AMP Worker TasksYou would need to look at the macro code SQL to know exactly how those fields are being calculated.  I am not an authority on the macro you are using, and unfortunately I do not have a copy wi...
28312 Jun 2013 @ 04:24 PDTcarrie's blogHow to Calculate Your Max Number of Usable AMP Worker TasksIt is good to hear that the webinar was helpful.   I don't use the Higa charts, but I believe that the MAX of MAX AWTs is the number that represents the highest inusemax count acros...
28210 Jun 2013 @ 09:09 PDTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Hi Ian,   That auto adjustment to the sampling percent is not done in 14.0. This is implemented in 14.10. Somehow, this statement made it into the document prematurely, and I ...
28105 Jun 2013 @ 01:57 PDTcarrie's blogIntrepreting DBQL DelayTime in Teradata 13.10When a query is manually released from the delay queue, or if a query is demoted into a workload that has a throttle whose limit has already been reached, the query count for that throttle will tem...
28005 Jun 2013 @ 01:56 PDTcarrie's blogReserving AMP Worker Tasks? Don’t let the Parameters Confuse You!Suhail,   WorkEight is the number of expedited new work requests (similar to WorkNew).   WorkNine is the number of expedited spawned requess (similar to WorkOne).   AWT L...
27930 May 2013 @ 09:09 PDTcarrie's blogAre AMP Worker Tasks used by FastExport in Response Mode?Geeta, The product join indicator uses this formula:   (AMPCPUTime * 1000)/TotalIOCount   Usually if it is 3 or higher it may indicate something that needs further investigation, but...
27830 May 2013 @ 09:06 PDTDatabaseSkew-Sensitivity in the Optimizer: New in Teradata 12Please continue to work with the support center on this issue.  They are the preferred point of contact if you believe you are experiencing a product deficiency.  I am not able to pr...
27724 May 2013 @ 04:02 PDTDatabaseSkew-Sensitivity in the Optimizer: New in Teradata 12If you are getting a worse plan for this query after upgrading to 14.0, and it looks like you are, I suggest you open an incident with the support center.   Thanks, -Carrie
27624 May 2013 @ 04:01 PDTcarrie's blogAre AMP Worker Tasks used by FastExport in Response Mode?The AWT Limit setting is by default 50 in Workload Designer. The AWT limit value does not indicate how many AWTs are in the reserved AWT pool.  That is determined by the Reserved AWT setting.&...
27524 May 2013 @ 03:54 PDTcarrie's blogStatistics collection recommendations – Teradata 14.0ppg- The same recommendations for recollection of statistics apply no matter what the table size.  10% change is just a rough guess, but it is all that we have to recommend at this time. ...
27421 May 2013 @ 04:37 PDTcarrie's blogRequest Cache Hits & MissesSuhail,   Suhail,   I don't know the exact process for doing this.   It has to do with defining a host group that links to sessions coming from specific IP addresses wit...
27321 May 2013 @ 04:35 PDTcarrie's blogAre AMP Worker Tasks used by FastExport in Response Mode?I do not have an answer to the question.   In order to get the best response for technical questions you have that are unrelated to the topic of the blog posting, please post them on Teradat...
27221 May 2013 @ 04:32 PDTcarrie's blogSimplifying AMP Worker Task Monitoring and Getting it RightSuhail,   Fastload has two receiver tasks (a workone and a worktwo) while MultiLoad only has one (workone) during the acquisition phase. This is because FastLoad uses a pre-sort approach whe...
27116 May 2013 @ 07:39 PDTcarrie's blogEntering and Exiting a TASM StateI am not an expert in the JDBC area, but my undestanding is that you will get two rows in DBQL with JDBC queries, one for the Prepare, and one for the query execution.  The row with the P...

Pages