Calculating database connections required by the CDC Replication Engine for FlexRep

This topic includes the formulae and examples to help you calculate the number of connections required by CDC Replication.

Calculating connections required by CDC Replication on a target database

(4+G)*I + 3*S

Where:

  • G = number of Management Console GUI and CHCCLP scripting applications that are connected to your instances of CDC Replication.
  • I = number of CDC Replication instances.
  • S = number of subscriptions in all of your CDC Replication instances.

Example: How to calculate required connections for a target database

You want to set up CDC Replication in the target environment as follows:
  • 1 installed Management Console GUI application.
  • 2 CDC Replication instances.
  • 3 subscriptions.

The number of connections required on the target database will be:

(4 + 1)*2 + 3*3 = 19

You should plan for a maximum of 19 database connections before installing CDC Replication on the target database.