595 | 08 Sep 2016 @ 01:26 PDT | carrie's blog | New opportunities for statistics collection in Teradata 14.0 | Hi Nazy,
If you don't collect stats for each separate combination, then there will no histogram where the optimizer can see the number of uniques and the interval values. So if y... |
594 | 07 Sep 2016 @ 09:37 PDT | carrie's blog | New opportunities for statistics collection in Teradata 14.0 | Hi Nazy,
The 32 bytes I mentioned is not directly related to MAXVALUELENGTH. MAXVALUELENGTH only applies to the number of characters that are stored in the histogram intervals ... |
593 | 07 Sep 2016 @ 08:25 PDT | carrie's blog | Easing Into Using the New AutoStats Feature | Chandra,
USECOUNT logging is not just used for skipping stats. It is also used for statistics extrapolation. You will not get skipping if USECOUNT logging is off, and the... |
592 | 01 Sep 2016 @ 04:00 PDT | carrie's blog | Easing Into Using the New AutoStats Feature | Response to the comment from 2 days ago:
Chandra,
The amount of time before skipping will be considered by the optimizer depends. The optimizer usually looks for at least 5 ... |
591 | 01 Sep 2016 @ 03:55 PDT | carrie's blog | How Resources are Shared in the SLES 11 Priority Scheduler | Samir,
Just to be sure that I understand what you mean when you say " In workload distribution, i see that we have only tactical and timeshare defined" Are you ... |
590 | 23 Aug 2016 @ 04:48 PDT | carrie's blog | Easing Into Using the New AutoStats Feature | Chandra,
Below are the responses I was able to get to your questions:
YOUR QUESTION: Can you advise on archiving the TDSTATS database ,statsmanager user setup. I read the ma... |
589 | 22 Aug 2016 @ 08:13 PDT | carrie's blog | Easing Into Using the New AutoStats Feature | Chandra,
I have been trying to find someone in engineering who knows what the answer is. When I am able to get a response, I will post it here. Thank you for the re... |
588 | 08 Aug 2016 @ 08:54 PDT | carrie's blog | Determining Precedence Among TASM Planned Environments | Nazy,
Unfortunately, I can't tell you what settings would be best for you without being there on site and seeing all the workload management detail as a whole.
 ... |
587 | 04 Aug 2016 @ 01:00 PDT | carrie's blog | Determining Precedence Among TASM Planned Environments | Hi Nazy,
It is not a recommended practice to move a workload to a different tier across planned environments. I don't believe Viewpoint Workload Designer will even al... |
586 | 28 Jul 2016 @ 01:52 PDT | carrie's blog | Statistics Collection Recommendations – Teradata 14.10, 15.0 and 15.10 | Chandrasekhar,
The NoDot0Backdown setting needs to be changed to TRUE. The logic used by Analyze Jobs to detect staleness relies on UDI counts from USECOUNT logging in conjunction with the... |
585 | 21 Jul 2016 @ 08:10 PDT | carrie's blog | Using the ResUsageSAWT table to Monitor AMP Worker Tasks | Hi Helena,
If you are running out of AMP worker tasks (AWT) that can slow a query down. Query steps require AWTs to execute, and if all the AMPs a query step is running in do n... |
584 | 27 Jun 2016 @ 04:41 PDT | carrie's blog | New opportunities for statistics collection in Teradata 14.0 | Hi Nazy,
I can't think of any reason there would be a value in collecting stats on rowID. RowIDs are often used in single-table join indexes as a means for the database cod... |
583 | 24 Jun 2016 @ 09:04 PDT | carrie's blog | How Resources are Shared in the SLES 11 Priority Scheduler | Amit,
You are correct in your basic understanding of how dynamic virtual partitions work. I also agree with you that using the dynamic sharing of resources between virtual part... |
582 | 17 Jun 2016 @ 02:32 PDT | carrie's blog | Statistics Collection Recommendations – Teradata 14.10, 15.0 and 15.10 | RESPONSE TO SECOND QUESTION:
If UDI counts are available, they will always be used instead of random AMP sampling. So if you see that your histogram for that statistic carries UDI co... |
581 | 17 Jun 2016 @ 02:31 PDT | carrie's blog | Statistics Collection Recommendations – Teradata 14.10, 15.0 and 15.10 | RESPONSE TO FIRST QUESTION:
Even if you have usecount logging on, the information is not able to be stored in the statistics histogram, and therefore cannot be used for extrap... |
580 | 10 Jun 2016 @ 03:58 PDT | carrie's blog | Statistics Collection Recommendations – Teradata 14.10, 15.0 and 15.10 | Katie,
The above posting constitutes overall recommendations on what statistics to collect. You will have to evaluate which columns in your tables these recommendations apply to.&nbs... |
579 | 10 Jun 2016 @ 08:08 PDT | carrie's blog | Expediting Express Requests | A change to the EnableExpReq does not require a restart.
You don't "throw a workload at it" because the EnableExpReq setting is applied universally, it is not targeted ... |
578 | 03 Jun 2016 @ 08:20 PDT | carrie's blog | Reserving AMP Worker Tasks? Don’t let the Parameters Confuse You! | Sachin,
You can consider applying the suggestions in my blog posting titled: " Expediting Express Requests". You have to reserve at least two AWTs in the tactical reserves ... |
577 | 03 Jun 2016 @ 08:18 PDT | carrie's blog | Easing Into Using the New AutoStats Feature | Naga,
The AutoStats APIs are implemented as stored procedures and are documented in the Application Programming Reference in the chapter entitled “Automated Statistics Management API... |
576 | 03 Jun 2016 @ 08:17 PDT | carrie's blog | Statistics Threshold Functionality 101 | If you want the system to consider downgrade to sampling, you have to turn off the system threshold option. As you say you have found out by trying it, if SysChangeTresholdOption is on, the o... |
575 | 27 May 2016 @ 01:44 PDT | carrie's blog | How Resources are Shared in the SLES 11 Priority Scheduler | Hi Naga,
A service level goal (SLG) is only for reporting purposes, so you can compare actual performance against your goals. It is optional. It sounds like you were under the ... |
574 | 27 May 2016 @ 01:42 PDT | carrie's blog | Reserving AMP Worker Tasks? Don’t let the Parameters Confuse You! | Hi Sachin,
An express request is usually issued in order to get particular information from the data dictionary, such as to validate the columns in a table that the query uses, or to get a... |
573 | 27 May 2016 @ 08:09 PDT | carrie's blog | AMP Worker Task Resource Limits & Increased Load Limits for MLOADX | Hi Samir,
First, only the TPT Update supports MLOADX. Standalone MultiLoad does not support MLOADX.
Second, in the default setting, the user just submits a TPT Update job and the ... |
572 | 23 May 2016 @ 03:04 PDT | carrie's blog | How Resources are Shared in the SLES 11 Priority Scheduler | Setting a service level goal (SLG) is an option within workload management. You are not required to set a service level goal for a workload, and it may not make much sense for most appl... |
571 | 23 May 2016 @ 09:19 PDT | carrie's blog | Easing Into Using the New AutoStats Feature | You are correct. Autostats uses tableIds to join it’s infrastructure (tdstats repository) with the dictionary.
Thanks, -Carrie
|