Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 09 Jan 2008 @ 14:43:41 GMT


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


Subj:   Re: Impact of a Heartbeat Query
 
From:   DOWNEYJ

In response to your post:

  We have a single heartbeat query set up on our database. IMHO, the heartbeat query should be just a quick query to verify that your database is up and running. The response time should be very quick, not impact the performance of the system, and be run often enough for your comfort. I run mine every 5 minutes. This could be as simple as select * from dbc.dbcinfo.  


At this frequency is it possible that this query or the results get cached so that your are not seeing a true picture of standard queries?



     
  <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: 27 Dec 2016