944,028 Members | Top Members by Rank

Ad:
  • MS SQL Discussion Thread
  • Unsolved
  • Views: 1706
  • MS SQL RSS
Jul 11th, 2007
0

Replication Issues

Expand Post »
Hi all,

I now have four server

SERVER A is acted as distribution server
SERVER B, C is acted as publication server
SERVER D is acted as subscription server

A is located with same network segment with B and C.
D is located with different network segment.

Server B and Server C is a heavy duty server.

So, how can i check on

1. time and data size ( replication command that send from time to time )from SERVER B, C to SERVER D?
2. time and data size ( replication command that going to push to subscription server ) from SERVER B, C to SERVER A?

Basically, i wish to know the traffic information among these servers to adjust my schedule task and also the network design...

The link between A,B,C and D broke down when the server B, C become busy during office hour...

Or, is it a good practice to put Server A as distribution and not put together with SERVER B and SERVER C?

Hope to get reply from your all soon.

Thanks in advance.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
kktung is offline Offline
1 posts
since Jul 2007
Aug 3rd, 2007
0

Re: Replication Issues

Click to Expand / Collapse  Quote originally posted by kktung ...
Hi all,

I now have four server

SERVER A is acted as distribution server
SERVER B, C is acted as publication server
SERVER D is acted as subscription server

A is located with same network segment with B and C.
D is located with different network segment.

Server B and Server C is a heavy duty server.

So, how can i check on

1. time and data size ( replication command that send from time to time )from SERVER B, C to SERVER D?
2. time and data size ( replication command that going to push to subscription server ) from SERVER B, C to SERVER A?

Basically, i wish to know the traffic information among these servers to adjust my schedule task and also the network design...

The link between A,B,C and D broke down when the server B, C become busy during office hour...

Or, is it a good practice to put Server A as distribution and not put together with SERVER B and SERVER C?

Hope to get reply from your all soon.

Thanks in advance.

The default for microsoft is every 15 minutes, I can't remeber off hand the exact details of how to reduce the network over load/ increase the timings, but is documented on the Microsoft technet site by searching under replication
Reputation Points: 10
Solved Threads: 0
Newbie Poster
Wil 0' Wisp is offline Offline
15 posts
since Jun 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS SQL Forum Timeline: quick question
Next Thread in MS SQL Forum Timeline: Return invoices of the given product with last available contact information





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC