x

Estimating Time for Replication?

I did Merge Replication by using RMO. Every thing is working fine.. Progressbar, Log Files and the status message , Every thing is working kool in my app. But can we estimate the time ? (time to sync data from server to client or the whole replication process)

Regards Bhuvan
more ▼

asked Jun 13 '11 at 05:28 AM in Default

Bhuvans gravatar image

Bhuvans
220 17 19 21

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first
If you have the process already set up, you can monitor the times. So set up a test with a known data set, measure that and then extrapolate as necessary. Same way you'd estimate any other time on the system. Do this with the knoweldge that when you have multiple users on the system and there may be resource conention, time estimates could change. If you monitor your servers regularly you should be able to make some predictions in that regard too.
more ▼

answered Jun 13 '11 at 05:59 AM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
91k 19 21 74

is this possibe? because i am doing merge replication by using public IP to the server. I dont have much experience on replication, i am using first time
Jun 13 '11 at 08:57 PM Bhuvans
Yes, it's possible to come up with an estimate. It won't be possible to come up with a guaranteed set of performance metrics because there are too many possible factors interfering, but yeah, you can create an estimate.
Jun 14 '11 at 03:24 AM Grant Fritchey ♦♦
how should i handle it? Which factors should i consider while estimating ?
Jun 14 '11 at 03:33 AM Bhuvans
I'd do it the same way I'd do any other performance estimation, I'd do testing. Get a known data set of a certain size and then run it multiple times, preferably through different internet connections, once from home, once from the office, once from the coffee shop, etc. Get the measures of those times, document the speeds of those connections, then say, when connected at speed x we can expect an average merge time of y. At speed z, time q... etc. Testing is your friend.
Jun 14 '11 at 04:06 AM Grant Fritchey ♦♦
Wow., Ok ., :)
Jun 14 '11 at 05:14 AM Bhuvans
(comments are locked)
10|1200 characters needed characters left
That's going to be really tricky as there are so many things that can vary that will affect replication times - locking transactions, high CPU, network latency, disk I/O, index health and so on... Are you trying to deal with giving the user an estimate of remaining work during replication cycle?
more ▼

answered Jun 13 '11 at 07:23 AM

Fatherjack gravatar image

Fatherjack ♦♦
41.3k 73 77 107

yes i am trying to estimate the remaining work and time(if possible), because now i am able to show the log to the user by using this handler

MergeSub.SynchronizationAgent.Status += new AgentCore.StatusEventHandler(agent_Status);
Jun 13 '11 at 08:54 PM Bhuvans
Can we calculate time like this, estimated data in MB to transfer , Network Download speed. by using the above two factors can we get the time takenb to transfer..
Jun 13 '11 at 09:00 PM Bhuvans
Or else do we have any method to calculate the estimated replication time in RMO
Jun 13 '11 at 10:26 PM Bhuvans
I would give a cost based estimate then, if you know the amount of data to replicate and how much has been then you can give a % complete figure ...
Jun 14 '11 at 01:54 AM Fatherjack ♦♦
ok , how to go with cost based estimate? I had 187 Mb of data ( 2 lk records in a table)
Jun 14 '11 at 02:25 AM Bhuvans
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1816
x293
x47

asked: Jun 13 '11 at 05:28 AM

Seen: 1637 times

Last Updated: Jun 13 '11 at 05:28 AM