#DateWhereItemComment
49517 Aug 2015 @ 08:18 PDTcarrie's blogRecommended Dictionary Statistics to Collect in Teradata 14.0Roopalini,   I don't have a list of DBC stats recommendations focused especially onr the 15.0 release.  What you can do is use the recommendations in the  blog posting for coll...
49413 Aug 2015 @ 04:50 PDTcarrie's blogEasing Into Using the New AutoStats Feature  An EventType of ‘U’ indicates an existing collected statistic was observed as being Used during query optimization as recorded by the DBQL STATSUSAGE logging option.  When ...
49310 Aug 2015 @ 11:18 PDTcarrie's blogNew, Simplified Approach to Parsing Workload SelectionSachin,   I am not familar with that situation.  You may want to open an incident with the support center, or ask your question of someone with expertise in Viewpoint.   Thanks, ...
49207 Aug 2015 @ 08:32 PDTcarrie's blogA Closer Look at How to Set up a Parsing-Only WorkloadNick,   Parsing prioritization is based upon the concept of session classification.  Session classification happens with TASM if you are on either SLES 10 or SLES 11.   It als...
49106 Aug 2015 @ 08:56 PDTcarrie's blogGlobal Weights in SLES 11 Priority SchedulerRoland,   Enable expedited express requests allows express requests to use the same higher work types as tactical requests.  But express requests will only be expedited if the...
49006 Aug 2015 @ 08:48 PDTcarrie's blogExpediting Express RequestsRoland,   "Express requests" are not a new feature.  Did you mean "the ability to expedite express requests"?  That is a new capability.   If that is wha...
48905 Aug 2015 @ 08:01 PDTcarrie's blogStatistics Collection Recommendations – Teradata 14.10, 15.0 and 15.10In general, HELP STATS doesn’t do anything to the confidence levels.   However, one possibility could be random AMP sampling.   The HELP STATS  operation logic triggers ...
48827 Jul 2015 @ 03:10 PDTcarrie's blogEasing Into Using the New AutoStats FeatureYoann,   The intent of the AcctString input parameter is to be a single account string, although it does support wildcarding.   The account string input parameter behav...
48727 Jul 2015 @ 03:02 PDTcarrie's blogEasing Into Using the New AutoStats FeatureResponse to Sravani:   There is no required maintenance involved in the ObjectUsage table.      I have heard any complaints about the overhead involved in enabling...
48627 Jul 2015 @ 02:58 PDTcarrie's blogNew opportunities for statistics collection in Teradata 14.0  The following recommendations for multicolumns statistics are made in my blog posting on statistics collection recommendations for 14.10:   Collect Multicolumn Statist...
48527 Jul 2015 @ 02:55 PDTcarrie's blogGlobal Weights in SLES 11 Priority SchedulerSandeep,   You are correct that for the Appliance, the global weight that is available for Timeshare workloads is 1 or 100% of all global weight in the system, since there is only a single v...
48421 Jul 2015 @ 09:29 PDTcarrie's blogNew, Simplified Approach to Parsing Workload SelectionSandeep,   I am not sure that I have understood your question completely.  If you question has to do with commands like SHOW and HELP that do not show a WDID in DBQL, that is because th...
48316 Jul 2015 @ 01:10 PDTcarrie's blogExpediting Express RequestsGangadhar,   I think you may have posted this question under the wrong blog.  The topic here is expediting express requests in the database.    If you have Viewpoint questio...
48224 Jun 2015 @ 09:58 PDTcarrie's blogConverting CPU Seconds, Old Node Type to New Node TypeSubramanian,   I'm not familiar with the formula or calculations involved in determing the TPERF value for a given hardware node.   I believe those are internally determined by...
48112 Jun 2015 @ 07:55 PDTcarrie's blogA Closer Look at How to Set up a Parsing-Only WorkloadThe purpose of the Parsing-only workload is to elevate the priority of CPU usage on the parsing engine when a session logs on or a query undergoes parsing/optimization.   This CPU usage o...
48010 Jun 2015 @ 09:30 PDTcarrie's blogExpediting Express RequestsStarting in 13.10, Viewpoint Workload Designer is the only way you can interact with workload management settings, including setting reserves for tactical work.   Thanks, -Carrie
47904 Jun 2015 @ 09:25 PDTcarrie's blogHow Resources are Shared in the SLES 11 Priority SchedulerOrange books are available several ways:   If you are Teradata associate you can find them in the share point orange book repository.  There are several tools available in Teradata to s...
47804 Jun 2015 @ 09:19 PDTcarrie's blogStatistics Collection Recommendations – Teradata 14.10, 15.0 and 15.10Wasif,   It's always helpful to provide the database release that you are on when it comes to statistics, as many things have changed in current releases.   If you are on 14.10 or...
47704 Jun 2015 @ 09:11 PDTcarrie's blogEasing Into Using the New AutoStats FeatureSandeep,   You can only a approve a missing stat for collection if it is recommended by the analyze job.   Basically only recommendations that made the TOP-N final cut thru the Sta...
47627 May 2015 @ 01:00 PDTcarrie's blogEasing Into Using the New AutoStats FeatureSandeep,   I suggest you double-check the following in your Collect Job definition:   1. Verify the Scope of the Collect Job includes the table containing the approved missing stat &...
47526 May 2015 @ 12:36 PDTcarrie's blogHow Resources are Shared in the SLES 11 Priority SchedulerA query is mapped to a workload, whether the workload is in Timeshare or not, based on the classification criteria that the workload has been given.   If a query matches the classificatio...
47420 May 2015 @ 04:40 PDTcarrie's blogTwo Levels of Concurrency Control for Load Utilities in Teradata 13.10Imad,   Another alternative is to add exclude criteria to the tactical workload classification that excludes on TPT Export, or all utility types.   But check evalation order firs...
47320 May 2015 @ 04:37 PDTcarrie's blogTwo Levels of Concurrency Control for Load Utilities in Teradata 13.10Imad,   NOCLASSIFICATION and WDOVERRIDE flags are set to TRUE for statements that are within utility jobs.   It looks like the CHECK WORKLOAD END statement of TPTEXP was classified in...
47220 May 2015 @ 08:46 PDTcarrie's blogExpediting Express RequestsRahul,   I don't have a threshold value in mind when it comes to ParserExpReq.  You could compare it to ParserCPUTime.   Some requests are more complex and may have high P...
47120 May 2015 @ 08:45 PDTcarrie's blogStatistics Threshold Functionality 101Harsha,   If you believe that you cannot use USECOUNT logging, then you will not have update/delete/insert counts that the percent of change threshold relies on.  If that is the case, y...

Pages