November 21, 2009 at 1:49 pm
Im comparing reinitialization methods ( snapshot and db backup) to see if one is quicker than the other. usually we use snapshot, but this can take up to 18 hours. the reason we know it takes this long is because we know when we kick it off, and we monitor using replicaiton monitor continously. this is not an accurate method though and requires someone in front of a pc monitoring at all times.
I need a way to monitor how long replication initializaiton takes without having to stare at replication monitor. i have checked perfmon counters, but they only show throughput of the various agents, but no real indicaiton of when initialization started or finished.
has anyone faced this problem and how have you overcome it?
November 23, 2009 at 1:20 am
Each replication process is carried out by a SQL Agent job.
You should be able to find your snapshot job (it will have a ctegory "REPL-Snapshot), and then it's just a case of looking at the job history.
November 23, 2009 at 4:49 am
Thanks for the reply.
im trying to compare initialization by snapshot vs initialization via backup of publisher restored to Subscriber.
In the case of initialization by backup, should i monitor the distribution agent instead?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply