Running multiple database instances on a single SQL Azure database

advertisements

I'm running 3 web apps (for different customers) which each run a separate database instance. Two apps need a database with less than 2GB storage each, and the third app requires about 10GB of storage.

Looking at the SQL Azure database plans, I can use the "Basic" plan for the first two, but I need to get the Standard S0 for the third. This gives me up to 250GB of storage, which leaves a lot of excess capacity. Is there a way I can utilize the S0 database for my other two apps while still maintaining separate logical database instances?


Yes, you can - this is called Azure Elastic Pools https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool