The Service tab of the Service Properties dialog allows you to limit the number of connections that the Replicator Service uses to communicate with its control database. It also displays the version number of the service being managed.
If you change either of the connection settings, the changes take effect as soon as you approve the properties. However, the exact timing depends on the number of active and pooled connections currently present, and on the old and new values for both settings. If you decrease the value of Maximum Connection Pool Size, any excess pooled connections will be closed immediately. If you set Maximum Number of Connections to a value that is less than the number of connections currently in use, Data Replicator allows replications that are in progress to finish before closing their connections. Therefore, some time may pass before the actual number of open connections decreases to the new maximum value. Connection information displayed in the right pane of the main window reflects this situation.
Maximum Number of Connections |
Sets the maximum number of connections between the Replicator Service and the Control database. This limit applies only to connections between the Replicator Service and the control tables. It does not limit the number of connections that are allowed between the Replicator Service and sources or destinations residing on the same computer as the control tables. The Maximum Number of Connections must be greater than or equal to the Maximum Connection Pool Size. |
Maximum Pooled Connections |
Sets the maximum number of unused connections that are kept open between the Replicator Service and the Control database. Leaving a connection open can improve performance because it eliminates the overhead of allocating and deallocating a connection. If you want to specify a timeout period after which the Replicator service will automatically close a pooled connection, specify a Time Limit on the Service Properties Connection Pools Tab. |
User |
If Role Based Access (RBAC) is enabled, this section displays the User Name and Group Membership of the user currently logged on, and allows users to change their password. |
Replication Service Version |
Displays the version of the Replication Service being managed. |
Managing Control Database Connections