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
From the course: Azure Database Administrator Associate (DP-300) Cert Prep: 1 The Azure Data Platform
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
-
-
-
-
-
(Locked)
Azure SQL Database PaaS4m 1s
-
(Locked)
Backups, replication, and failover groups2m 13s
-
(Locked)
Deploy Azure SQL Database9m 2s
-
(Locked)
Connect to Azure SQL Database1m 45s
-
(Locked)
Add a database to an elastic pool4m 26s
-
(Locked)
What is a SQL Server Managed Instance?2m 47s
-
(Locked)
Set up SQL Data Sync for Azure4m 22s
-
(Locked)
-
-
-
-