#DateWhereItemComment
47019 May 2015 @ 10:54 PDTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Hi Sandeep,   Here are responses to your questions:   1.  Whether or not you will need to collect stats depends on whether it is a UPI or a NUPI.  For example, a UPI does no...
46914 May 2015 @ 08:20 PDTcarrie's blogEntering and Exiting a TASM StateIn 15.0 you have an option to create multiple planned environments on the appliance platform.   When you get to that release you will be able to automate a change the priority of workload...
46808 May 2015 @ 10:05 PDTcarrie's blogIntrepreting DBQL DelayTime in Teradata 13.10Haritha,   Basically,  you can take the difference between StartTime and FirstStepTime and assume that it represents parsing time.  But if there delay time due to a throttle, then ...
46701 May 2015 @ 04:51 PDTcarrie's blogUsing the ResUsageSAWT table to Monitor AMP Worker TasksDinesh,   I found information about setting  or unsetting the summary flag on page 73-74 of Graphical User Interfaces: Database Window and Teradata MultiTool manual.  B035-1095-067...
46629 Apr 2015 @ 03:33 PDTcarrie's blogUsing the ResUsageSAWT table to Monitor AMP Worker TasksHi Dinesh,   The AWTLimit field in ResUsageSAWT was first introduced in 14.0.  AWTLimit did not exist in the SAWT base table in earlier releases, such as 12.0.  These are the only ...
46529 Apr 2015 @ 08:33 PDTcarrie's blogTeradata 13.10 Statistics Collection Recommendations Teradata does not support hints to the optimizer.  So there is no mechanism to say don’t use a sliding window join. In general, a sliding window join is beneficial as it joins the ...
46427 Apr 2015 @ 08:26 PDTcarrie's blogEasing Into Using the New AutoStats FeatureYou mentioned both multivalue compression.   There is no overhead when reading a table that contains multivalue compression.   Please refer to the Database Administration Manual if...
46323 Apr 2015 @ 08:12 PDTcarrie's blogUsing the ResUsageSAWT table to Monitor AMP Worker TasksDinesh,   I am not clear from your comments if you seeing invalid values in the DBC.ResUsageSAWT table itself, or in some other table where you have offloaded the DBC table's data. ...
46220 Apr 2015 @ 03:41 PDTcarrie's blogDetermining Precedence Among TASM Planned EnvironmentsMy apologies for the delayed response Smarak,     The search for the correct Health Condition starts at the bottom with the highest severity Health Condition an...
46116 Apr 2015 @ 09:37 PDTcarrie's blogEasing Into Using the New AutoStats FeatureSandeep,   I don't have anything more to add than what is in the knowledge article.    Once you have opened an incident on a problem with the GSC, it is best to continue to w...
46016 Apr 2015 @ 09:35 PDTcarrie's blogEntering and Exiting a TASM StateHuzain,   Instead of using two different rulesets, you can create two different TASM planned environments in the same rule set and TASM will automatically change to the different state by ti...
45908 Apr 2015 @ 01:30 PDTcarrie's blogControlling the Flow of Work in TeradataThere is usually more activity with WorkNew than with WorkOne AWTs.  Every request-step that executes requires a WorkNew AWT just to get started.   And if there are two or three...
45808 Apr 2015 @ 01:26 PDTcarrie's blogEasing Into Using the New AutoStats FeatureSandeep,   Here are some details that describe the implications of using Automate in different ways:   -              ...
45727 Mar 2015 @ 03:16 PDTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Hi Nazy,   Statistics are always collected on the entire table.  There is no capability in 14.10 to just collect stats on a single partition.  That capability may be added at some ...
45620 Mar 2015 @ 09:47 PDTcarrie's blogStatistics Collection Recommendations – Teradata 14.10, 15.0 and 15.10Socola,   Starting in  14.10, statistics can be collected on BEGIN/END(valid_time/transaction_time) since we support expression statistics. However, note that we don’t allow colle...
45520 Mar 2015 @ 09:45 PDTcarrie's blogStatistics Threshold Functionality 101Sandeep,   I have not heard of any issues with UseCount logging overhead being problematic.  UseCount logging uses the same techniques as other DBQL collections.  There is a UseCou...
45417 Mar 2015 @ 04:22 PDTDatabaseTo Peek or Not to Peek, That is the QuestionKawish,   You are correct, there will be a space in the cache flag field if the request is nto parameterized.  But even non-parameterized requests could have their plans cache...
45316 Mar 2015 @ 02:50 PDTcarrie's blogEasing Into Using the New AutoStats FeatureNazy,   The two main factors that influence how long an Analyze job runs are 1.)  the number of logged queries; and 2.)  the average size of the logged XML files.  So the size...
45216 Mar 2015 @ 02:47 PDTcarrie's blogEasing Into Using the New AutoStats FeatureSandeep,   There is another blog posting titled Statistics Threshold Functionality 101 that answers your questions.    It provides this explanation:   "System thre...
45106 Mar 2015 @ 01:16 PSTcarrie's blogUsing the ResUsageSAWT table to Monitor AMP Worker TasksI cannot think of any way you can tell how many AWTs a user is holding in real time.    There is no information inside the database that records how many AWTs a given query...
45006 Mar 2015 @ 01:12 PSTcarrie's blogRecommended Dictionary Statistics to Collect in Teradata 14.0Geeta,   The frequency with which you collect statistics on the data dictionary tables will depend on  1.)  How long it takes;  2.)  How frequently the DD tables actually...
44906 Mar 2015 @ 01:09 PSTcarrie's blogNew, Simplified Approach to Parsing Workload SelectionPierre,   The number of CPU seconds used for parsing compared to the number of CPU seconds used for AMP work will depend on the type of query that is executing.  I have seen examples si...
44805 Mar 2015 @ 08:24 PSTcarrie's blogIntrepreting DBQL DelayTime in Teradata 13.10You would have to use DBQLogTbl to examine query-level detail.  The ResUsageSPS table reports information about workloads, but not individual queries within a workload.   DBQLogTbl has ...
44705 Mar 2015 @ 08:21 PSTcarrie's blogConverting CPU Seconds, Old Node Type to New Node TypeTo  know how many of the new nodes you need, you have to track past, current, and expected future CPU usage, and determine how much CPU you will require after adding new nodes. It is imporant ...
44604 Mar 2015 @ 02:47 PSTcarrie's blogNew, Simplified Approach to Parsing Workload SelectionPierre,   Each DBQLogTbl row represents an entire request, parsing and AMP work combined.   There are no "session-only rows" in DBQLogTbl, there are only "request ro...

Pages