Link to home
Start Free TrialLog in
Avatar of Brian DeBolt
Brian DeBoltFlag for United States of America

asked on

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

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.
Avatar of Zachariah Browning
Zachariah Browning
Flag of United States of America image

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>?
Avatar of Brian DeBolt

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of Zachariah Browning
Zachariah Browning
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial