I have a fairly large table and I have updates 1.2 million rows on the Primary. The replication performance is very slow. There is a text column on this table.
I am using profiler to see the performance on the target end. It says CPU time is @200ms and Duration is @210ms. The number of locks acquired on this table is very high. There is not much going on the target end.
I cloned this table and performed an update on one row and it takes just 12ms. I am not sure what is going on. Any pointers to improve performance will help!
View Complete Post