May 5, 2011 at 7:24 am
we are running sqlserver 2005 merge replication. we are getting the following error message on some of our subscriptions:
The process is waiting for a response from the query '{call sp_MSuplineageversion(?,?,?)}'
it does not happen all the time. it usually causes the sync to hang.
any ideas would be appreciated.
May 5, 2011 at 11:42 am
Have you checked for blocking requests on the subscribers/publisher?
Query sys.dm_exec_requests to find out if, and who is blocking who.
If you want more detailed info about requests and blocking, you could also download a proc called aba_lockinfo. Google it.
May 5, 2011 at 12:04 pm
we have been monitoring the blocking on the activity monitor. blocking is not always occuring while we are having this problem.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply