#DateForumTypeThreadPost
1202 Jul 2009 @ 10:52 PDTAnalyticsTopicAnother Question regarding DBC.AMPUSAGEWhen usage is logged in AMPUSAGE, and we include the &D&H in the Account name, does the CPU and Disk IO get logged against multiple Days and Hours if the same unit of work spans that far?IE if I ru...
1101 Jul 2009 @ 10:27 PDTAnalyticsReplydbc.ampusageIf you view the "view" using Teradata Administrator, you can list the columns. Which are AccountName UserName CpuTime DiskIO CpuTimeNorm Vproc ...
1001 Jul 2009 @ 09:43 PDTDatabaseReplyBYNETI found this helpful, don't know if it answers your questions.http://it.toolbox.com/wiki/index.php/BYNET
901 Jul 2009 @ 09:26 PDTDatabaseReplyHow to speed up inserting data into volatile table ?Correction below. I tried to bold the parts to replace, but they were missing after I posted! BOLD does not work! SELECT HASHAMP(HASHBUCKET(HASHROW( FIRST COLUMN GOES HERE ))),COUNT(*) ...
801 Jul 2009 @ 09:22 PDTDatabaseReplyHow to speed up inserting data into volatile table ?Check the distribution with the following SELECT HASHAMP(HASHBUCKET(HASHROW( ))),COUNT(*) FROM ( ) as test_table GROUP BY 1replacing the 2 parts.This should give you the ...
701 Jul 2009 @ 08:07 PDTDatabaseReplyDBQLOGTBL SPOOL USAGE NOT CORRECT IN TD12How are you measuring?
601 Jul 2009 @ 05:55 PDTDatabaseReplyMeasuring Query reponse time.Thanks guys for the responses. I have also spoken to Teradata Support and they confirm that they cannot get the end of the transaction, they suggest we put in a RFC, but said not the expect any im...
530 Jun 2009 @ 08:11 PDTDatabaseReplyMeasuring Query reponse time.Thanks Dieter,The lastresponse time never did work, perhaps I was too optimistic, I hoped that it would be fixed rather than removed with TD12.I have an example query . simply select * from dbc.qr...
430 Jun 2009 @ 05:46 PDTToolsReplyPerformance TuningI am also new to Teradata, but not performance management in general.Can you elaborate on what you are looking to tune? You could tune queries, which would involve looking at the access paths, dat...
330 Jun 2009 @ 05:35 PDTToolsReplyPE and AMPIts basically a process running on the underlying linux (or windows, whatever). Its not a Virtual Processor in Server technoloy terms, its not a division of a Physical CPU as you would find on Lar...
230 Jun 2009 @ 04:26 PDTDatabaseReplyMeasuring Query reponse time.Thanks for the reply, I think I need to clarify. I am not worried about performance at the minute, I do not need to tune queries. Our system was going to go live with a huge SAS and Data mining co...
129 Jun 2009 @ 08:21 PDTDatabaseTopicMeasuring Query reponse time.Hi,I am trying to determine the length of time a query takes to run under Teradata. We run TD V12.The view DBC.qrylog contains metrics to show the time a query was submitted, the time it "first" r...

Pages