We help IT Professionals succeed at work.

How to validate health of network connecting between servers located in office and those on cloud

178 Views
Last Modified: 2014-12-29
We are having performance issues regarding data replicating between a DB server located on our local server and another on the cloud.

I want to check that the network between the nodes if functioning as expected over the  2mb dedicated pipe we have.  I need some guidance on tools to use and how to interpret results to assess the health and performance of the network.

I've started and included trace routes done from both servers shown below.  Perhaps these are enough though I'm uncertain if the times are what I should be expecting.

From Local to Cloud:

Local server
From Cloud to Local:

Cloud server
Comment
Watch Question

2mb pipe isn't exactly huge. What is the physical distance in miles between your premise and your cloud location?

Author

Commented:
The office is based in Florida and I believe the cloud location is in Maryland so say 1000 miles roughly.
Okay. Given the distance and the assumption that the connection right now is not under excessive load, then 45msec isn't out of the realm of ordinary latency.
It might be interesting to perform these same tests while attempting replication.
What is the size of the DB/dataset you're attempting to replicate across this pipe?

Author

Commented:
I'll do another test when replication kicks off tomorrow morning and post the results.

The size of the entire db (mdf file) is just under 2GB.
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
I'm doing snapshot replications.  The reason for this is every morning this the source database on local is completely refreshed from a non-sql data source.  I then take a snapshot which replicates over to the cloud.  Since all the tables on the local db are truncated I thought snapshot was the way  to go.  Does this approach make sense to you?
It's probably the safest way to make sure you have a complete dataset in the cloud post-replication, yeah. Bandwidth limitations are always a challenge.
Just to verify, when you say 'performance issues', do you mean the replication takes a long time, or fails, or speed to the net stinks during replication?

Author

Commented:
It seems to slow at points.  When I look in Replication Monitor it sometimes waits for some time on "Waiting for System response". I was wondering if that might have been caused by network faults or some other related limitation.

I guess what I need to do is work out exactly how much data is transferred (not just look at the size of the mdf) and how long it takes.  I can then compare actual mb/sec and compare that to the ideal.  Is there a way to do that?  I can tell from Replication Monitor how long it took but I'm not sure how to work out how many mb were transferred.
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Thank you!
It's a pleasure to help.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.