Azure SQL Databases (or Managed Instance) are great options over self-hosting and managing SQL Server, there are several advantages for example it drastically reduces management overhead of having to manage the Virtual Machine, HA setup etc.
However, when it comes to hosting a large number of databases for example