#DateForumTypeThreadPost
3729 Jul 2009 @ 03:46 PDTDatabaseReplyThoughts on CPUBusy caclulations.Thanks for the confirmation Dieter. For others I have attached the SQL I use to extract the days CPU Utilisation. I hope its useful to others. Random. select thedate, cast(cast(ca...
3629 Jul 2009 @ 01:47 PDTDatabaseTopicThoughts on CPUBusy caclulations.A few people in our organization are slightly disbelieving of the CPU utilisation charts I produce, they always focus on the CPU utilization charts, as if it is the only metric to be interested in....
3529 Jul 2009 @ 01:41 PDTDatabaseTopicIOWAIT on Teradata systemsIf I query the DBC.ResUsageSpma table (We use Linux based servers) I find that the IOWAIT can consume up ti 80% of the resource. Now the standard Unix definition for IOWAIT would be that ...
3424 Jul 2009 @ 05:24 PDTDatabaseReplyCan anyone format the DelayTime from DBC.QryLogTDWMV?Dieter, I think you are right. The manual certainly says that StartTime The timestamp when the query is submitted. FirstStepTime The timestamp when the first step is dispatched. ...
3324 Jul 2009 @ 01:19 PDTDatabaseReplyCan anyone format the DelayTime from DBC.QryLogTDWMV?Dieter, I used viewpoint to view transactions in the Delay queue, I could rewind and see the query above being submitted 50 minutes 12 seconds before. I seem to have come to the conclusion that...
3223 Jul 2009 @ 07:02 PDTDatabaseReplyCan anyone format the DelayTime from DBC.QryLogTDWMV?@Dieter, Thanks for prompt response. Putting into a query and running SELECT Starttime,Firstresptime,DelayTime , DelayTime * INTERVAL '0000:00:01' hour to second FROM DBC.DBQLogtbl wh...
3123 Jul 2009 @ 05:58 PDTDatabaseReplyanother Compression QuestionOk, so CPU resource is used to return decompressed rows back to the client? If so where is this CPU usage logged? (The record has been logged in DBQL by this point) Can any of the Teradata peop...
3023 Jul 2009 @ 05:38 PDTDatabaseTopicCan anyone format the DelayTime from DBC.QryLogTDWMV?Anyone help in converting the DelayTime into hours:minutes:seconds where hours could be greater than 24? I cant seem to get my head around this "Teradata" way of recording times! Thanks in a...
2922 Jul 2009 @ 08:06 PDTTeradata ApplicationsReplyExperience of TRSGreat, thanks for the answers.
2822 Jul 2009 @ 02:59 PDTDatabaseReplyTeradata compressionI don't know if there are any rules of thumb, but the Performance Management Manual has *some* information. It implies to that for maximum performance benefit with compression(Value-list compr...
2722 Jul 2009 @ 01:27 PDTDatabaseTopicanother Compression QuestionAs a query runs and returns rows from a compressed table into spool, are the columns compressed in the spool space?
2622 Jul 2009 @ 01:25 PDTDatabaseReplyTeradata compressionThere will be an impact, could be faster or slower. The scale of the impact will range from negligible to significant, because somewhere the system will have to uncompress the data. The CPU used ...
2521 Jul 2009 @ 12:38 PDTTeradata ApplicationsReplyExperience of TRSAre there any Rules of thumb for sizing the Replication Servers, and is it right that the TRS servers can be Either Windows or AIX or Linux? What do Teradata prefer to deploy? or what do the 6-9 ...
2421 Jul 2009 @ 12:37 PDTTeradata ApplicationsTopicExperience of TRSDoes anyone here use TRS? If so is it reliable? How much Data do you replicate? All or just a few tables? How many TB or GB do you replicate per day?
2319 Jul 2009 @ 02:14 PDTDatabaseReplySELECT TOP N - odd behaviour (v2r6)@rluebke - Could you expand on this a little? what clue in the Explain do you see that leads you to think it needs more up to date Stats? I saw that it read 209 million rows, so it must have stat...
2217 Jul 2009 @ 06:58 PDTDatabaseReplySELECT TOP N - odd behaviour (v2r6)I am no expert here, I am just learning the "Teradata way", but I think this is repartitioning your data, doing an all AMP scan of all rows and and building a spool file on each of the amps, then ...
2117 Jul 2009 @ 01:12 PDTGeneralTopicSuggestion for a new Forum?Would a forum topic to cover Performance management and capacity planning for Teradata systems be useful? I think its a topic on its own. How do other users manage and monitor and measure the...
2017 Jul 2009 @ 12:55 PDTGeneralReplySite does not seem to work under IE6Thanks, the "Missing updates bar" removal seems to have vastly improved the whole experience. As you say there are many alterations to IE, we must use a modified version here as its config is tied...
1916 Jul 2009 @ 07:45 PDTGeneralReplySite does not seem to work under IE6I cleared the Cache out on this PC, and hid the show features bar on the top, it seems to work much better now, but the "missing updates bar" that IE throws up wants only to update to IE8. I do...
1816 Jul 2009 @ 06:52 PDTGeneralTopicSite does not seem to work under IE6I know IE 6 is old and past its best, it does not support some of the whizzbang CSS stylings etc. I am a web developer in another life, and hate having to make sites IE6 compatible, but it is a co...
1716 Jul 2009 @ 06:35 PDTGeneralReplyWelcome to the Teradata Developer Exchange discussion forums!Any plans to move the content of the old forums over to this forum.
1614 Jul 2009 @ 11:39 PDTDatabaseReplyDelayTimeDieter,Delay time is the one I meant, We use the Workload manager and it is delaying SAS queries. I was praying that those numbers were milliseconds.Thanks for the help.Random.
1514 Jul 2009 @ 10:13 PDTDatabaseTopicDelayTimeHi,I am wanting to know the delay time for queries, I would like to know the Submit time for a query and the time it started.The DBQLogtbl has a column DelayTime, does anyone know the unit of measu...
1406 Jul 2009 @ 07:09 PDTToolsTopicWDID in tables?In the table DBC.TDWMsummaryLog the WDID column, is there a table I can link to to get a more meaningful description? or even more information about it?
1306 Jul 2009 @ 06:35 PDTDatabaseReplyHintsOn our recent Teradata courses, we were told that it didn't support hints.You need to make sure your runstats are all up to date, and the optimizer will take care of the rest.

Pages