•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 423,512 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,658 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser: Programming Forums
Views: 948 | Replies: 1
![]() |
•
•
Join Date: Jul 2007
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
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.
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.
•
•
Join Date: Jun 2007
Posts: 10
Reputation:
Rep Power: 2
Solved Threads: 0
•
•
•
•
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
![]() |
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
- What's better? Windows 2000 Server or Linux Server? (Windows Servers and IIS)
- ASP.NET and Mozilla - Issues! (ASP.NET)
- SuSE 9.1 - Minor issues (*nix Software)
- Error messages, Taskbar changes in XP + USB connectivity issues. (Windows NT / 2000 / XP / 2003)
- Login issues (Web Browsers)
- Mail apps issues - error port 25 (Mac Software)
- Security Issues (*nix Software)
- Graphics Card issues Stop Command??? (Windows NT / 2000 / XP / 2003)
Other Threads in the MS SQL Forum
- Previous Thread: quick question
- Next Thread: Return invoices of the given product with last available contact information


Linear Mode