From the course: Azure Database Administrator Associate (DP-300) Cert Prep: 1 The Azure Data Platform

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

Add a database to an elastic pool

Add a database to an elastic pool

- [Instructor] When you need to run multiple databases, it's recommended that you leverage an elastic pool of resources. When we set up our Azure SQL database, one of the steps was to choose a specific service tier. This provisioned our database with a certain compute and storage capacity. You can share those resources across multiple databases by adding them into a common elastic pool. You can think of this like a single on-premises SQL server instance that contains multiple user databases. The instance makes decisions about its processor and memory allotments and how best to divide them up between all of the databases on that instance. Elastic pools bring this same flexibility to the cloud. To get started with elastic pools, we're going to go back up into the Azure Marketplace. Then we'll search for Azure SQL. When you locate the Azure SQL Marketplace entry, go ahead and click it, then press Create. In the SQL Databases Option, change the resource type to elastic pool, and then…

Contents