Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 03 Apr 2015 @ 14:00:03 GMT


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


Subj:   Re: Canary Queries - TO Analyze System response
 
From:   Tomas GORNER

Hi Sravan,

Do not concentrate on CPU consumption only. Look at IOs, AWT usage, Disk and CPU skew...

You can also try to get as much information as you can about the canary query itself from DBQL:

Was the canary query long at some particular step?

Was there a bottleneck at parsing time?

Was the query not blocked by some other transaction?


Regards,

Tomas



     
  <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: 23 Jun 2019