Home > Archive > MS SQL Server Replication > January 2006 > How much inbound traffic should i receive to my distributor with transactional replication









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author How much inbound traffic should i receive to my distributor with transactional replication
combfilter

2006-01-17, 1:23 pm

I am reviewing my firewall logs and I have a boat load of inbound mssql
data returning to my distributors as far as bytes received. Why would
this be? Figured the traffic should be outbound only.

tia

-comb
Hilary Cotter

2006-01-17, 8:23 pm

The way firewalls work is that it is bi-directional communication, but
typically blocked in one direction by initialization. So you can only
initialize communication from one side of the DMZ, but not both.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"combfilter" <asdf@adsf.com> wrote in message
news:MPG. 1e36f1112c45593b9896
e3@news.newsreader.com...
>I am reviewing my firewall logs and I have a boat load of inbound mssql
> data returning to my distributors as far as bytes received. Why would
> this be? Figured the traffic should be outbound only.
>
> tia
>
> -comb



Michael Hotek

2006-01-23, 7:23 am

Every send cycle also needs to receive an acknowledgment from each
subscriber of the rows that were successfully received along with any errors
that were encountered. There is a LOT of polling that goes on along with
all of these ack cycles that adds up to a considerable amount of traffic.

--
Mike
http://www. solidqualitylearning
.com

Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.

"combfilter" <asdf@adsf.com> wrote in message
news:MPG. 1e36f1112c45593b9896
e3@news.newsreader.com...
>I am reviewing my firewall logs and I have a boat load of inbound mssql
> data returning to my distributors as far as bytes received. Why would
> this be? Figured the traffic should be outbound only.
>
> tia
>
> -comb



combfilter

2006-01-23, 8:24 pm

In article <#4d8F1BIGHA.2040@TK2MSFTNGP14.phx.gbl>,
mike@solidqualitylea
rning.com says...
> Every send cycle also needs to receive an acknowledgment from each
> subscriber of the rows that were successfully received along with any errors
> that were encountered. There is a LOT of polling that goes on along with
> all of these ack cycles that adds up to a considerable amount of traffic.
>
>

ahhh thanks for the answer. This makes sense.
-comb
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com