Item: Azure SQL Managed Instance
Rating: 9
Author: Verified User

Overall Satisfaction with Azure SQL Managed Instance

Use Cases and Deployment Scope

Run our supply chain applications using Azure*SQL developed in micro-services architecture.

Pros and Cons

Pros

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

Cons

be able to find situation where it uses a bad query plan due to lack of right stats
auto scale the CPU when load requires it
auto update stats has opportunities in it. so people still have to restart to stopping auto update stats for some situations

Return on Investment

it had a positive impact to my business and allowed me to be able to move my workload from on-premise to cloud.

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.

Alternatives Considered

IBM Informix

Key Insights

Do you think Azure SQL Managed Instance delivers good value for the price?

Yes

Are you happy with Azure SQL Managed Instance's feature set?

Yes

Did Azure SQL Managed Instance live up to sales and marketing promises?

Yes

Did implementation of Azure SQL Managed Instance go as expected?

Yes

Would you buy Azure SQL Managed Instance again?

Yes

Likelihood to Recommend

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.

Azure SQL Managed Instance Feature Ratings

Comments

Please log in to join the conversation

Azure_SQL a good rdbms for cloud