I'm using a merge replication with SQL 2008 at server and SQL Express 2008 on subscribers.
We are using around 100 subscribers.
I'm getting the following error once two subscribers replicate at the same time. The final number of transaction uploaded to the server is always arong 100 and a similar number in the downloads, so the amount of transaction is not an issue.
I'he been playing with the merge profile with no luck.
The merge process could not replicate one or more INSERT statements to the 'Publisher'. A stored procedure failed to execute. Troubleshoot by using SQL Profiler. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147200990)
Get help: http://help/MSSQL_REPL-2147200990
A query executing on Publisher 'xxxxx' failed because the connection was chosen as the victim in a deadlock. Please rerun the merge process if you still see this error after internal retries by the merge process. (Source: MSSQLServer, Error number: 1205)
Get help: http://help/1205
This is getting to a critical point where transactions are not being uploaded to the server.
Additonally, there are a lot of blocks between the subscribers, and they are mainly associated with table
View Complete Post