July 23, 2010 at 7:05 am
Hello,
I have a bunch of servers, one of which performs replications really slow. After few days of trying to do whatever I can to enhance its speed, I tried to configure to Log Reader to dump everything it does to a text file. Among the things I noticed on that dump is that its ratio of fetch time to write time is about 300-1 (i.e. for each 300 seconds of fetching it would do 1 second of writing... numbers in this example are arbitrary) This is one point in which the slow server differs from all other servers, in which I usually get 12-1 ratio.
Could it be that Iām on to something? Am I correct in gathering that the problem is clearly in reading, then? and if so, does anybody has any idea on how to continue from here?
Thanks!
Jonathan
July 26, 2010 at 8:54 am
Log reader reads it from your publishers log file. The only reason why it can be slow is IO bottleneck at the publisher.
-Roy
July 27, 2010 at 8:09 pm
yonision (7/23/2010)
Hello,I have a bunch of servers, one of which performs replications really slow. After few days of trying to do whatever I can to enhance its speed, I tried to configure to Log Reader to dump everything it does to a text file. Among the things I noticed on that dump is that its ratio of fetch time to write time is about 300-1 (i.e. for each 300 seconds of fetching it would do 1 second of writing... numbers in this example are arbitrary) This is one point in which the slow server differs from all other servers, in which I usually get 12-1 ratio.
Could it be that Iām on to something? Am I correct in gathering that the problem is clearly in reading, then? and if so, does anybody has any idea on how to continue from here?
Thanks!
Jonathan
Hello,
When you say replication is slow, is it slow from Pub -dist or dist -subscriber ?
You may want to look at the size of the dist DB also and see if the clean up jobs are running fine.
HTH,
Cheers !
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor š
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply