Azure SQL database system design

Mark Anyon | Fission IT 0 Reputation points

Looking for some advice
We have two applications which in current form the front end application runs on PCs, and talks to a SQL database which runs on an on-prem server.

If we are to move the SQL database into Azure SQL PAAS, what is the most efficient way to run the application?
Are we likely able to still have the front end application running on local PC and connect to Azure SQL over site to site VPN? Will performance be ok?

Another way is to run a Remote Desktop Server in Azure and put the app on there and have users connect via RemoteApp, then both SQL and the app are running in Azure

Are their other ways of setting this up to leverage Azure SQL and get good performance?

Azure SQL Database
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Rajkumar V 1 Reputation point


    I think the best would be to go for Azure Web apps for the UI - simpler architecture below


  2. KalyanChanumolu-MSFT 8,316 Reputation points

    VPN performance will depend on the type of connection you have between your OnPremise location and Azure
    You should see high throughput and minimal latency if you are using ExpressRoute.

    Please check this article for more details on the types of connections

    Provisioning a Remote Desktop on Azure (often referred to as JumpBox) is also a solution depending on the number of users and VMs required.
    You could use low cost Azure Spot Machines for this purpose

    Let us know if you have further questions

    If an Answer is helpful, please “Accept Answer” or Up-Vote for the same which might be beneficial to other community members reading this thread.

    0 comments No comments