#DateWhereItemComment
57020 May 2016 @ 04:44 PDTcarrie's blogStatistics Threshold Functionality 101Hi George,   Offhand, I don't know of a way to apply USING NO THRESHOLD to all the stats for a table.  You could turn off SysChangeThresholdOption if you don't want threshold to...
56920 May 2016 @ 08:51 PDTcarrie's blogUsing the ResUsageSAWT table to Monitor AMP Worker TasksThis is explained in a different blog posting titled  "How to Calculate Your Max Number of Usable AMP Worker Tasks"  at this location:   http://developer.teradata.com/blo...
56820 May 2016 @ 08:45 PDTcarrie's blogExpediting Express RequestsWhat is a "high" value for ParserExpReq depends on the the complexity of the queries being executed and whether the system is congested or not.   You could try to establish a &q...
56712 May 2016 @ 02:50 PDTcarrie's blogA Closer Look at Tactical Workload Exceptions Harsha,   Unfortunately, there is no option in TASM to manage a query once it moves into the responding state.  TASM relinquishes all control at that point.  I'm not sure I hav...
56612 May 2016 @ 02:49 PDTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Hi Mark,   The optimizer will ATTEMPT to collect multiple stats in one pass of the table when you use the coding below, but often it decides there is no cost savings in doing so and will rev...
56512 May 2016 @ 02:45 PDTcarrie's blogStatistics Threshold Functionality 101You are correct that usecount logging must be enabled for the database involved before skipping will be considered.  You don't have to specify USING SYSTEM THRESHOLD on the collect stats s...
56428 Apr 2016 @ 09:14 PDTcarrie's blogTeradata Basics: ParallelismTeradata Forum has a category called "Data Modeling" which describes itself as:   Discussion topics on Logical Data Models, Physical Data Models, and Semantic Modeling Building ...
56318 Apr 2016 @ 10:03 PDTcarrie's blogBeing Smart About Using Workload Classification  Steven,   When you specify a table name in Viewpoint, you have to select the database name first.   The "table" as a classification criteria is actually a "dat...
56218 Apr 2016 @ 08:11 PDTcarrie's blogEasing Into Using the New AutoStats FeatureI don't see anything problematic with your evaluation order.   You  have the workloads with the most restrictive classifications first, which is good. The only way that an Analyz...
56112 Apr 2016 @ 12:51 PDTcarrie's blogUtility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED)You don't need to  calculate the number of sessions yourself.  The purpose of session management is to do that for you in the database.  The formula that session management uses ...
56012 Apr 2016 @ 12:49 PDTcarrie's blogAutomated Demotions on the Appliance: What are Query Milestones?In the Viewpoint User Guide for 15.0, it lists "Workload" as one of the Query Monitor portlet columns that you can choose to display.  See page 259-260. Once you have the workload na...
55904 Apr 2016 @ 12:59 PDTcarrie's blogCPU Limits at Multiple Levels The 6800 does not support PM COD.  WM COD is the only supported option for COD on the 6800.    If you were actually using platform metering (PM) COD on the 6800 because of so...
55830 Mar 2016 @ 02:50 PDTcarrie's blogStatistics collection recommendations – Teradata 14.0Robin,   I don't know of any way of "tuning" a collect statistics statement, in the way you might try to tune a regular query.   A collect stats statement is going to...
55730 Mar 2016 @ 10:38 PDTcarrie's blogEasing Into Using the New AutoStats FeatureChandra,   At a mininum, you need STATSUSAGE logging enabled for an Analyze Job to making recommendations regarding missing and used stats.  Enabling the XMLPLAN option as well may resu...
55630 Mar 2016 @ 10:35 PDTcarrie's blogIf You’re Not Collecting Statistics on Your Dictionary Tables, Do It. Now.Lakshminiarasu,   When you use the diagnostic help stats command, you may get more suggestions for statistics collections than you actually need.   Unfortunately,  it's di...
55530 Mar 2016 @ 10:04 PDTcarrie's blogConverting CPU Seconds, Old Node Type to New Node TypeGeeta,   The definitions you show below for CPUUServ and CPUUExec are taken from the ResUsageSPMA table (Chapter 6 in the ResUsage manual), which reports node-level metrics.  They are n...
55425 Mar 2016 @ 10:18 PDTcarrie's blogConverting CPU Seconds, Old Node Type to New Node TypeGeeta,   In 13.10 the CPUTime is provided in the SPS table and is reported in milliseconds.  This column is removed from the table on 14.0 and up.   In 14.10, the CPUTime is prov...
55325 Mar 2016 @ 08:21 PDTcarrie's blogA Closer Look at How to Set up a Parsing-Only WorkloadFor question #1:  Requests that classify to a tactical workload will not be helped by setting up a parsing-only workload.  That is because tactical queries will do their parsing work in t...
55225 Mar 2016 @ 08:10 PDTcarrie's blogStatistics collection recommendations – Teradata 14.0Robin,   By any chance are you collecting statistics with the USING SAMPLE option? If sampled stats are being collected on a NPPI table, when you change to a PPI table the optimizer may deci...
55119 Mar 2016 @ 08:28 PDTcarrie's blogConverting CPU Seconds, Old Node Type to New Node Type Geeta,   The reason  CpuTime was removed was because it was duplicating the information provided by the sum of the other fields.  We were reducing the cost of the SPS tabl...
55017 Mar 2016 @ 09:00 PDTcarrie's blogAMP Worker Task Resource Limits & Increased Load Limits for MLOADXSuhail,   In order to force TPT Update jobs to use MLOADX you would have to change the DBSControl Internal field 296 to 2.      296. MLoadProtocol - This field ena...
54907 Mar 2016 @ 09:45 PSTcarrie's blogSimplifying AMP Worker Task Monitoring and Getting it RightTheTime is defined in the Resource Usage Macros and Tables  manual as:  Nominal time of the log entry.   Since the log entry is not made until the end of the interval, this me...
54804 Mar 2016 @ 10:13 PSTcarrie's blogThings that Run in the Session WorkloadSteven,   If you want to add target criteria to a workload so that all stored procedure CALL statements will run there you would select Target Critieria, then Stored Procedure in the drop do...
54703 Mar 2016 @ 03:22 PSTcarrie's blogRejection CAN be RewardingAmar,    You need to add the table as target selection criteria first, then specify no table scans as subcriteria to that table:   If you want the filter rule to apply only to fu...
54625 Feb 2016 @ 08:28 PSTcarrie's blogStatistics Collection Recommendations – Teradata 14.10, 15.0 and 15.10There is no method for just collecting incremental statistics on Teradata currently.   You can collect stats on expressions starting in 14.1, but that will not help you with a partitioned...

Pages