Azure App Service vs. Azure SQL Managed Instance

Azure App Service is well suited in our case :

• Our website is developed by our tech partner in a full Microsoft Azure cloud based environment.
• We gave them specific access rights and the CI / CD integration helped a lot for updates and improvements deployment.
• Most of the infra issues we had with our website weren't coming from App Service

Incentivized

Runs the supply chain workload well. Able to provide proper alerts when the cpu is not enough to run the workload. Is able to run the update stats automatically as the data changes. Scales very well for most oltp apps. Has good dashboards to show what is going on the database.

Incentivized

• Super quick & easy to deploy new apps in visual studio
• Easy scaling to help reduce costs during off-hours
• The powerful Azure ecosystem offers a lot of functionality that ties in well with Azure App Service

Incentivized

• executes the queries efficiently
• has tools/dashboards to show where the query problems lie
• alerting for problems

Incentivized

• Abstraction of computing resources like Heroku does with dynos.
• Azure Portal overall is pretty bloated and that affects managing Azure App Service applications.

Incentivized

• hard to use without Microsoft knowledge
• Intimidating CLI
• Commands are not intuitive

Incentivized

I enjoy the fact that Azure App Service can be managed by the Azure portal and a fully graphical user interface, as well as from two different flavors of command-line interface, i.e. Azure CLI and Azure Powershell. By utilizing the Azure Cloud Shell, we are able to switch between Azure Bash (CLI) and Powershell at any given moment and manage the Azure App Service settings from devices of any form-factor (Web based management).

Incentivized

it runs the workload very well without causing any issues to the business. there are many applications running on Azure SQL Managed Instances in my organization. Most users are happy with its performance. Is able to provide good dashboard for the visibility of the workload. Can add cpu without a downtime to deal with high workload.

Incentivized

We had an issue where we deployed too large of a resource and didn't notice until the bill came through. They were very understanding and saw we weren't utilizing the resources so they issued a generous refund in about 4 hours. Very fast, friendly, and understanding support reps from my experience.

Incentivized

In terms of deploying your apps, Azure App Service provides a solid foundation. You may use either the Azure command-line interface or the Web Portal to administer these apps. As a whole, I find You may easily deploy your apps to Azure App Service to be a really difficult platform for novices to get their feet wet. First and foremost, I'd look at Heroku's user interface and the way it abstracts compute units.

Incentivized

Azure to our enviironment where we have everything integrated stacks up far better than MySQL where we would have to reinvent and use everything to fit a MySQL environment including the data and the commands within that data. Furthermore, doesn't work really well on SQL Management Studio which makes it completely useless for what we are trying to do.

Incentivized

• Download time is reduced because of auto scaling feature.
• Insight tool helps in finding issues quickly.
• CI/CD has helped in automation.

Incentivized

• Decision Driven decisions have been quicker
• Negatively cumbersome at start when training
• Positive use of PaaS services instead of devoting VMs

Incentivized