Azure_SQL a good rdbms for cloud
Rating: 9 out of 10
IncentivizedUse Cases and Deployment Scope
Run our supply chain applications using Azure*SQL developed in micro-services architecture.
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
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.
Vetted Review
5 years of experience