Business Continuity Manager uses one of the following methods to synchronize the changes made in managed routing sessions:
- SQL Multicast
- CDM
Business Continuity Manager parses the incoming request to identify the tables and rows affected by the request and whether the query is deterministic. By default, Business Continuity Manager uses SQL Multicast to replicate changes. However, if the query is non-deterministic, Business Continuity Manager runs the request on the active system first and then replicates the change using CDM on the standby system.
If you do not want to use CDM replication for non-deterministic queries using an object, such as view, macro, or user-defined function, use the OBJECT SET DETERMINISM command to force Business Continuity Manager to use SQL Multicast.