Processing performance for Syniti Replicatevaries widely from one configuration to another. Processing time depends on the resources available:
Network bandwidth in connection between the DBMS servers and the server where Syniti Replicateis running;
Number of processors for the machines involved;
Types of processors;
Memory available;
CPU usage.
Replication design needs to be carefully balanced to avoid bottlenecks during the replication process. Any measures you take depend on:
Number of source and target connections;
Number of tables in replication;
Record size and record numbers for each table replicated;
Replication mode (refresh, mirroring, synchronization);
Number of transactions per second on the source database.
Grouping of replications to optimize open database connections and query processing
For instance, the size of the table to be replicated and the number of transactions are important to evaluate whether it is more convenient to run continuous refreshes during the specified time, instead of a single full refresh and a continuous mirroring afterwards.
The Management Center provides access to the Dashboard, a tool to analyze replication data and perfoamance over a period of time based on the contents of a specified Metadata and history file or database. It can provides information for each table in a selected set of tables including:
Total number of processed records
Total number of failed records
Total number of records
Total number of replication sessions
Total number of processed records by all replications per unit of time.
Average time it took to replicate specified records.