Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 06 Dec 2002 @ 16:11:14 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: V2R5 Query Log vs Ambeo Usage Tracker
 
From:   Matthew Winter

Hi,

As part of Anita Richards presentation at Partners, the following stats were given showing the aproximate times required for each insert into each of the DBQL tables. Since DBQL can be configured to only record queries that have an elapsed time of a set value, the overhead can be reduced significantly. Leaving the Summary table to mop up all other queries.

DBQLogTbl      1 row per Query                     ~3.0ms per query

DBQLSummary    1-4 rows per session every 10 minutes
                 (1 row per response time interval with query count >0)

DBQLStepTbl    1 row per query step                ~1.5ms per step

DBQLObjTbl     1 row per each used object in a query     ~1.5ms per object

DBQLSqlTbl     1 or more rows per query            ~1.5ms per SQL row

Regards

Matthew Winter

Technical Architect
TPG IS Design Authority
Teradata Certified Professional



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023