- High network latency between the DA server and database servers
- Many concurrent comparisons
- The external sort function is used to work with very large tables
- Performance takes precedence over ease of deployment and maintenance
|
Distributed |
- Install the DA server component to Machine0.
- Install DA agent components to Machine1 and Machine2.
- Install additional DA agents to other machines if necessary.
To achieve maximum performance, a standalone DA agent can be installed on the same machine as the database server. This configuration removes any network latency between the database and the DA agent. Typically, the DA agent is a lightweight process and does not negatively impact the host machine.
However, in cases where the DA agent requires more CPU-time and disk space when used with the 'external sort' option (to avoid using SQL 'order by' when selecting data to compare), the preferred configuration is to install a standalone DA agent on a separate machine, which shares a fast ethernet connection with the database server.
- Complete the distributed deployment by creating an agent connection for each DA agent in the DA server, then assign database connections to the DA agent nearest the database servers.
|
