1 Reply Latest reply on Jan 10, 2014 2:05 PM by ChrisJenkins-Oracle

    How to measure Replication Throughput

    Pratheej

      Hi,

      Im using TT version 11.2.1.X

      Can I know how I can measure replication through where two datastatores are involved in different machines?

      From sys.monitor output I'm not able to get any data with this detail.

       

      Thanks

      Pratheej

        • 1. Re: How to measure Replication Throughput
          ChrisJenkins-Oracle

          TimesTen does not provide a single replication throughput metric. The best way to get a feeling for this is as follows:

           

          While your test workload is running:

           

          1.    Monitor the rate of transaction log data generation by running repeated 'ls -l' commands against the transaction log files for the database. With a bit of scripting you could create a script to report this in MB/s.

           

          2.    By using the ttRepAdmin -bookmark command (or the ttBookmark builtin procedure) and/or the ttLogHolds procedure you can see if replication is lagging. If it is not then you know that replication throughput is >= log generation rate. If replication is lagging then replication throughput is < log generation rate.

           

          Chris