CDC with Database Mirroring or Replication

Last Post 17 Dec 2008 05:58 PM by bryanmurtha. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
bryanmurtha
New Member
New Member

--
17 Dec 2008 05:58 PM
Hello,

My question has to do with Change Data Capture when used with a database that is princible in a mirroring situation or is the publisher in transaction replication. I'm hoping that the agent is singleton component and that these other services register handlers with the information they are interested in retrieving. What I'm fearful of is that these are independant processes acting on the transaction log and causing commit stalls. I've looked around but haven't been able to find anything that discusses this topic.


Acceptable Use Policy
---