 |
 |
Archives of the TeradataForum
Message Posted: Wed, 09 Jan 2008 @ 14:43:41 GMT
| 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?
| |
