Choosing the right service
As with any service available in the cloud, it is important to weigh the benefits and drawbacks of choosing one type of service over another, and this is applicable to database services as well. There are a few aspects that should help drive the decision toward the service you choose, along with some related questions you should ask regarding the use case you’re trying to address when planning for OLTP applications. There is also an informational page on OLTP data stores in the Azure Architecture Center that gives some side-by-side comparisons of key database services and features:
- Non-functional requirements:
- Availability: What is the guaranteed uptime of the database service? Does it meet the uptime requirements of your application?
- Maintainability: Is the database service mostly, if not fully, managed by the platform? Are there any aspects of the service that require additional configuration? If so, how complicated is that configuration?
- Observability...
