[askdba] Re: Bandwidth calculation and data transfer calculation

  • From: "Subodh Deshpande" <subodh_deshpande@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Wed, 13 Jul 2005 23:58:13 -0500

thanx justine..I will try..take care..subodh

----- Original Message -----
From: "Justin Cave (DDBC)" <jcave@xxxxxxxxxxx>
To: askdba@xxxxxxxxxxxxx
Subject: [askdba] Re: Bandwidth calculation and data transfer calculation
Date: Wed, 13 Jul 2005 08:06:48 -0600

> 
> I'm assuming here that by replication you mean materialized views.  If
> you are using Data Guard, Streams, or some other technology, the answer
> may be slightly different.
> 
> With any network protocol, there is going to be a degree of overhead
> above and beyond the payload of data that actually has to be
> transferred.  The simplest way to measure that overhead, and to
> determine how that overhead affects performance (different types of
> overhead will affect different types of networks differently) would be
> to do a test.  If you expect to replicate, say, 1,000,000 records a day,
> set up a test where you replicate 10,000 records (1%), and see how long
> that takes.  Repeat the test with 2%, 4%, 8%, etc. until you have an
> appropriate degree of confidence about how long replicating the real
> data will take and how much bandwidth will be consumed.
> 
> Justin Cave  <jcave@xxxxxxxxxxx>
> Distributed Database Consulting, Inc.
> http://www.ddbcinc.com/askDDBC
> 
> -----Original Message-----
> From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx]
> On Behalf Of Subodh Deshpande
> Sent: Wednesday, July 13, 2005 8:21 AM
> To: askdba@xxxxxxxxxxxxx
> Subject: [askdba] Bandwidth calculation and data transfer calculation
> 
> Dear All,
> 
> We are replicating some objects from one site to another.
> 
> I would like to measure the time taken for the replication of data from
> one location to another.
> 
> What is the simplest mesaurable method I should use.
> 
> > From Avg Rec length and num of records I can get the data to be
> transferred/replicated..and the network engineer does not agree with
> this..he says its more than that..
> 
> can any ideas..
> 
> Good Luck..Subodh Deshpande
> 
> ===============================================
> Experience Is Knowledge
> Wisdom Is Philosophy
> ==============================================
> 
> 
> 
> 
> 
> 
> 
> 
> --
> _______________________________________________
> NEW! Lycos Dating Search. The only place to search multiple dating sites
> at once.
> http://datingsearch.lycos.com



Good Luck..Subodh Deshpande

===============================================
Experience Is Knowledge
Wisdom Is Philosophy
==============================================








-- 
_______________________________________________
NEW! Lycos Dating Search. The only place to search multiple dating sites at 
once.
http://datingsearch.lycos.com


Other related posts: