Configuring elastic pools for Azure SQL Database
While 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 it on an existing database. In this demonstration, we are going to enable it 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...