Sachin Nandanwar (6/20/2014)
The deadlocks now typically involve inserts and deletes from the filter table and CRUD action against a table that has a foreign key to master table. The deadlocks are keylocks that the filter table creates.
Is dropping the master-child relationship as option ?
No. that is not where the deadlock is coming from. The deadlock comes between merge replication's filtered queries and user's transactions on that same filter table.