SQL and IIS on AZURE interfacing with on premise SQL and IIS

Posted on 2016-08-18
Last Modified: 2016-08-24
We currently have a site to AZURE vpn configured and we are getting 60ms ping times thru it.  We have integrated AD to our AZURE servers.  We have an on premise SQL server and an IIS server that host applications and databases for our internal users.  (12 db's none over 3gb).  We also have a SQL server and an IIS server hosted on AZURE that our external customers access.  The web server on AZURE gets data input and dumps it in the AZURE SQL server which replicates back into our internal SQL server.  Our internal SQL server gets input from our internal users and replicates to the AZURE SQL server.  We are having all sorts of database issues and failures.  Is this a viable way for doing this?  What other options do we have.  **Note**  The AZURE servers are our external webservers for the public.  This is not my forte.  This is actually our web/sql guys issue but he is not having any luck solving it.
Question by:Brian DeBolt
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2

Expert Comment

by:Zachariah Browning
ID: 41761901
My main question is why are you double replicating instead of having only the Azure SQL DB?

~Azure does not charge for data ingress- but does charge for all data egress, so every time you do a replication to on prem you have  a small little charge associated with it. From your description you want the two servers in as close to synchronized as possible.. if you are already in a VPN situation, why not just use the azure server directly and reconfigure on premises web servers to be directed to the Azure SQL DB>?

Author Comment

by:Brian DeBolt
ID: 41763008
When we try and run an app internally that queries the AZURE SQL we get about 10 rows of data every 30 seconds.  That's why we are not just using the AZURE SQL server.
I am curious if the issue is with our site to Azure VPN or using blob storage instead of premium storage?  A ping to our AZURE server over our VPN is between 60ms and 65ms.

Accepted Solution

Zachariah Browning earned 500 total points
ID: 41764320
Is your Azure SQL actually SQL running on an IaaS Server hosted in Azure or are you using the PaaS Azure SQL DB Service? You could be running into IOPS issues or DTU limits..

Most likely your issue is with your VPN setup/gateway device. not so much connection speed but high packet loss or bandwidth limitation somewhere. Some causes could be if azure is far away from your office like connecting to East Europe when you live in West Coast US. Issue with gateway setup/VPN device on premises. Multiple site-to-site vpn connections.

First i would check what the throughput is between on premises and Azure via VPN to test what your actual connection speed is. Since on the surface that sounds like the real issue. If you find that your throughput is very low then troubleshooting that network connection, gateway setup etc.- would be the main priority.

You could look into getting a ExpressRoute setup if your Internet Service Provider supports it. This would create a tunneled high security connection directly to azure for consistent and fast connection speeds. Just as one option. You might also want to upgrade your gateway to a Standard or high performance gateway if you are only using the basic gateway setup. Even a standard (or small)  dynamic routed gateway should have 100Mbps throughput, or 1000Mbps Expressroute throughput.

Featured Post

Learn by Doing. Anytime. Anywhere.

Do you like to learn by doing?
Our labs and exercises give you the chance to do just that: Learn by performing actions on real environments.

Hands-on, scenario-based labs give you experience on real environments provided by us so you don't have to worry about breaking anything.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Nano Server Image Builder helps you create a custom Nano Server image and bootable USB media with the aid of a graphical interface. Based on the inputs you provide, it generates images for deployment and creates reusable PowerShell scripts that …
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

626 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