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?