#DateWhereItemComment
1702 Sep 2010 @ 01:25 PDTcarrie's blogPenalty Box Over-Population Maybe we could create multiple penalty boxes with slightly different characteristics for each of them. Of course this will same implications for each penalty box but we can deal with them categoric...
1629 Jun 2010 @ 12:40 PDTConnectivitySpeed up your JDBC/ODBC applicationsCan a statement like this be useful for Prepared Statement? sel * ..... WHERE cast(CollectTimeStamp as timestamp) > cast('?');
1523 May 2010 @ 10:46 PDTcarrie's blogMore on ResUsageSAWT When Collection and Logging Rates DifferAppreciate your help. Thanks
1418 May 2010 @ 02:11 PDTcarrie's blogMore on ResUsageSAWT When Collection and Logging Rates DifferThank you very much Carrie. After using the CollectIntervals our data indeed looks good. Apart from the ResUsageSawt table we have some doubts around data aggregation for AWT data in ResUsageSpma....
1314 May 2010 @ 09:57 PDTcarrie's blogMore on ResUsageSAWT When Collection and Logging Rates DifferGood to know that the averages aren't skewed. If the logging rate and collect interval are the same then the AwtInUse count shouldn't be greater than the AwtInUseMax, right? And from your pre...
1213 May 2010 @ 11:26 PDTcarrie's blogMore on ResUsageSAWT When Collection and Logging Rates DifferCarrie, do the ResUsageSpma counterparts of these metrics behave in the same fashion? I'm talking about AwtInUse and AwtInUseMax which give data on a per node basis. AwtInuse --------- Number of...
1129 Apr 2010 @ 09:57 PDTcarrie's blogUtility Throttles – You Won’t Regret It!You mentioned that utility throttles can be used with or without TASM. Can you please provide a pointer to using these throttles without TASM?
1028 Apr 2010 @ 01:50 PDTcarrie's blogCPU Limits at Multiple LevelsExcellent post. From the content it looks like CPU limit is imposed all the times, at all cost by Teradata. I have a question related to TASM: If a query starts running in state 1 whose CPU Limit i...
907 Mar 2010 @ 09:10 PSTcarrie's blogSome Rules are Meant to be Broken: Things that Don't Obey CPU Limits Thanks for the confirmation.
802 Mar 2010 @ 08:39 PSTcarrie's blogSome Rules are Meant to be Broken: Things that Don't Obey CPU Limits Carrie, thanks for the detailed response. I didn't respond earlier because I was (and still am) unable to run schmon on my system (Windows) :( From your explanation, there is delay caused due to C...
723 Feb 2010 @ 03:16 PSTcarrie's blogSome Rules are Meant to be Broken: Things that Don't Obey CPU Limits Does imposing CPU limit result in a Delay Time or Throttle? An example: In TDWM, there is a WDs in an AG and that AG is assigned a CPU limit of 20% (rel. wt.). If there are 5 queries that classifi...
606 Jan 2010 @ 09:43 PSTcarrie's blogExpedite Your Tactical Queries, Whether You Think They Need It or NotThanks for the confirmation Carrie.
505 Jan 2010 @ 12:26 PSTcarrie's blogExpedite Your Tactical Queries, Whether You Think They Need It or NotThanks for the insightful article Carrie and also for sharing the trends at the Teradata sites. I would like to confirm one thing: We can accurately calculate the work done by these reserved AWTs ...
410 Dec 2009 @ 11:27 PSTcarrie's blogSimplifying AMP Worker Task Monitoring and Getting it RightGot it! This was really helpful, cleared up the confusion. (And yes, I meant "WorkOne") Thanks again.
309 Dec 2009 @ 09:18 PSTcarrie's blogSimplifying AMP Worker Task Monitoring and Getting it RightCarrie, thanks for explaining both the examples. Just to be clear, in the Real-World example, the value of WorkDone=140 corresponds to 600 seconds. And in the SQL Adjustment example, WorkDone=14....
208 Dec 2009 @ 09:30 PSTcarrie's blogSimplifying AMP Worker Task Monitoring and Getting it RightIn your example, the value of workdone represents the work done in 60 seconds. Right?
106 Sep 2009 @ 11:47 PDTDatabaseDBQL setup and maintenance scripts for Teradata Database 12.0Are there similar scripts for creating and populating ResUsage historical tables?