Using the heartbeat feature in RMS

To view latency information, use the heartbeat feature in the command line service, Replication Monitoring Services (RMS). The heartbeat feature uses the stored procedure rs_ticket to generate latency information, which is the amount of time it takes a transaction to move from the primary to the replicate database. At a specified interval, the RMS executes rs_ticket at a primary database. The latency information that has been generated is stored in a table in the replicate database.

RMS provides commands to set up the heartbeat process and to retrieve that latency information from the replicate database. The heartbeat feature is available only through RMS. See the Replication Server Reference Manual for more information about the heartbeat commands.