I am using merge replication with SQL 2012.

When performing a clean sync using the merge agent I am getting a timeout on this stored procedure,


I am wondering what the best way to diagnose this issue? When I take the SQL that was run, and run it in management studio it runs instantly. I can only assume that part of the required operations were done the first time it was run and timed out.

More specifically it must be a particular group of merge articles that are slowing it down, so how can I isolate this?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.