When the usage demands for an Azure SQL Database server are unpredictable during creation, SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases. The databases, in an elastic pool, share a set of resources at a set price.
You can configure elastic pools for an Azure SQL database in two different ways. The first is to enable it during the creation of the database server and database. The other option is to enable this on an existing database. In this demonstration, we are going to enable this on the database that we created in the first demonstration of this chapter. Therefore, we need to take the following steps:
- Navigate to the Azure portal, by opening https://portal.azure.com.
- Navigate to the overview blade of the Azure SQL database that we created in the first demonstration of this chapter. In the top menu, click on the link that is displayed next to Elastic pool, as shown in the...
