November 19, 2009 at 5:05 pm
Hello There,
I have transaction replication with distributor running continously. Snapshot is generated with immediate initialization option. However, I can see errors stating "Cannot perform Bulk copy" on my subscriber/distributor for every minute.
I have cross checked that snapshot is generated only once (ie in transaction replication) and there are no more schedule other than distributor agent.
I have 5 more replication with same setting running continously. After some investigation it is found that sp_msacquiresnapshotdeliverysession_lock stored procedure has been in held in shared lock by more than 3 process causing the dead lock.
Have any one come across this issue?.Any suggestions?
Ta
November 20, 2009 at 7:19 am
Well well well. It has been found continous synchronization of more than one publication when old one is generating the snapshot will lead in to deadlock and would fail bulk copy process of future publication. We get to see errors in log files as SQL server poll to see whether it can run the bulk process after some interval.
This creates the deadlock and system and all its application stop working.
Regards,
Vidhya
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply