Table of Contents

Search

  1. Preface
  2. Data Replication Overview
  3. Understanding Data Replication
  4. Sources - Preparation and Replication Considerations
  5. Targets - Preparation and Replication Considerations
  6. Starting the Server Manager
  7. Getting Started with the Data Replication Console
  8. Defining and Managing Server Manager Main Servers and Subservers
  9. Creating and Managing User Accounts
  10. Creating and Managing Connections
  11. Creating Replication Configurations
  12. Materializing Targets with InitialSync
  13. Scheduling and Running Replication Tasks
  14. Implementing Advanced Replication Topologies
  15. Monitoring Data Replication
  16. Managing Replication Configurations
  17. Handling Replication Environment Changes and Failures
  18. Troubleshooting
  19. Data Replication Files and Subdirectories
  20. Data Replication Runtime Parameters
  21. Command Line Parameters for Data Replication Components
  22. Updating Configurations in the Replication Configuration CLI
  23. DDL Statements for Manually Creating Recovery Tables
  24. Sample Scripts for Enabling or Disabling SQL Server Change Data Capture
  25. Glossary

Viewing Latency Statistics for Continuous Replication

Viewing Latency Statistics for Continuous Replication

On the
Latency
tab, you can view the latency of the Extractor, Applier, and Send File tasks by heartbeat for a continuous replication.
For each intermediate file, you can view transaction-related statistics. You can also view the average performance of each replication task and the total end-to-end replication latency for the continuous replication.
  1. In the
    Statistics
    window, click the
    Latency
    tab.
    The following image shows the
    Graph
    view of the
    Latency
    tab:
    Graph view of the Latency tab in the Statistics window
  2. In the
    Target
    box, enter a target connection.
  3. To view statistics for a specific time period, select
    Lookup
    . Then enter date and time values in the
    From Date
    and
    To Date
    fields.
  4. Click
    Request
    to display statistics.
    • The upper box displays latency statistics for the Extractor, Applier, and Send File tasks in terms of intermediate files. In the graph, a heartbeat corresponds to an intermediate file. The graph also shows the total latency for the Send File end-to-end replication.
      The
      Data
      view is a numeric representation of the graphed data. This view also includes the start and end times for the Extractor and Applier.
    • The middle box displays latency statistics for the Extractor, Applier, and Send File tasks and the total latency for the end-to-end replication aggregated by a week. You can move the time mark to get detailed statistics in the upper box for a specific period of time.
    • The lower box provides the average latency across all of the intermediate files. The
      Graph
      and
      Data
      views show the average latency for the Extractor, Applier, and Send File tasks and the end-to end replication. The
      Data
      view also shows the average total time and absolute total time for end-to-end replication.
  • Click
    History
    to display a historical statistics graph similar to the upper one on the
    Latency
    tab but with additional aggregation by time. You can aggregate by seconds, minutes, hours, days, and weeks.
  • Click
    Clean
    to clear the graph contents to start again.
  • Click
    Save to File
    to save the table in the upper
    Data
    subtab to a text file.

0 COMMENTS

We’d like to hear from you!