Different Flavor of Azure SQL Database

We have three different Kind of Databaase deployment in Azure SQL database:

•          Singleton:
•          Elastic Pool:
•          Managed Instance

Singleton : With a single database, each database is isolated from each other and portable, each with its own service tier within the DTU-based purchasing model. The single database deployment option creates a database in Azure SQL Database with its own set of resources and is managed via a SQL Database server.

Elastic Pool: SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands. The databases in an elastic pool are on a single Azure SQL Database server and share a set number of resources at a set price.

Managed Instance: A managed instance in Azure SQL Database is a fully managed SQL Server Database Engine Instance hosted in Azure cloud. This is the best PaaS option for migrating your SQL Server database to the cloud.

Note: For Azure SQL Database single databases and elastic pools, only master Database and tempdb Database apply. For Azure SQL Database Managed Instance, all system databases apply. For more information on Managed Instances in Azure SQL Database

Post Reference: Vikram Aristocratic Elfin Share