Solved

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

Posted on 2014-12-19
11
116 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
0
Comment
Question by:canuckconsulting
  • 6
  • 5
11 Comments
 
LVL 11

Expert Comment

by:rharland2009
ID: 40509351
2mb pipe isn't exactly huge. What is the physical distance in miles between your premise and your cloud location?
0
 

Author Comment

by:canuckconsulting
ID: 40509398
The office is based in Florida and I believe the cloud location is in Maryland so say 1000 miles roughly.
0
 
LVL 11

Expert Comment

by:rharland2009
ID: 40509438
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?
0
 

Author Comment

by:canuckconsulting
ID: 40509453
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.
0
 
LVL 11

Assisted Solution

by:rharland2009
rharland2009 earned 500 total points
ID: 40509479
Okay. Are you doing change-only replication, or is this a full replication of that 2GB dataset?
Moving 2GB across that link - given no other load and perfect conditions - will still take between 2 and 3 hours.
And of course, conditions are not usually perfect!
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

Author Comment

by:canuckconsulting
ID: 40509521
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?
0
 
LVL 11

Expert Comment

by:rharland2009
ID: 40509534
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?
0
 

Author Comment

by:canuckconsulting
ID: 40509549
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.
0
 
LVL 11

Accepted Solution

by:
rharland2009 earned 500 total points
ID: 40509560
Not SQL-specific, but you can set up a Performance Monitor counter for bytes transferred. It's not perfect, but will give you some picture of the data flowing out of your local box.

http://www.sqlshack.com/sql-server-network-performance-metrics-important-metrics/
0
 

Author Closing Comment

by:canuckconsulting
ID: 40521822
Thank you!
0
 
LVL 11

Expert Comment

by:rharland2009
ID: 40521832
It's a pleasure to help.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

We recently endured a series of broadcast storms that caused our ISP to shut us down for brief periods of time. After going through a multitude of tests, we determined that the issue was related to Intel NIC drivers on some new HP desktop computers …
Trying to figure out group policy inheritance and which settings apply where can be a chore.  Here's a very simple summary I've written which might help.  Keep in mind, this is just a high-level conceptual overview where I try to avoid getting bogge…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now