May 20, 2009 at 8:24 am
Hi
I have a problem with a subscriber, on looking at the locks/object section of EM, I can see almost a thousand or so Mode X exclusive / IX locks on one of the articles.
This is making the replication from the publisher fail because of the locks and the fact that its waiting for it to release the locks, these locks are held on the database for over 12 hours or so. I then have to kill off the transaction, and the replication starts once again.
One thing though, the latency between the 2 sites are very slow, and its transactional replication. One other thing is that, the article (table) in question seems to get bulk updates all of a sudden atimes.
Any advice here.
May 20, 2009 at 8:38 am
Although U must have tried this but I will start from basics.
(A) Is it possible to have dirty reads on some of the transactions using nolock in your application or isolation level to be read uncommited on your BULK operation?
(B)Is it possible to break the Bulk inserts happening in smaller transactions?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply