Azure SQL Database vs Cosmos DB

2021-02-23T05:25:02+00:00

Azure SQL Database Azure Cosmos DB Type of Database Relational database NoSQL database Features Has several SQL deployment options for different kinds of workloads - SQL databases, SQL managed instances, SQL virtual machines. Delivers single-digit millisecond response times and instant scalability. Storage Size 100 TB for SQL database 8 TB for SQL managed instance 256 TB for SQL virtual machine Unlimited storage per database and container. Availability SQL database - 99.995% availability SQL managed instance and SQL virtual machine - 99.99% availability Single-region - 99.99% Multi-region - 99.999% Backups With long-term backup retention policy, database backups are automatically retained [...]