In this hands-on lab, we will learn how to create an elastic pool and tie databases to that pool using the Azure Portal.
Learning Objectives
Successfully complete this lab by achieving the following learning objectives:
- Configure an Elastic Pool Using the Azure Portal
Create a SQL database.
- Provide a unique server name in (US) East (US).
- The server should have 10 DTUs and 100 MB of storage in the Standard tier.
- Name the SQL database "lalearning1".
- For Want to use SQL elastic pool?, choose No.
Create a second SQL database.
- Use the server from the first instance.
- The server should have 10 DTUs and 100 MB of storage in the Standard tier.
- Name the second SQL database "lalearning2".
- For Want to use SQL elastic pool?, choose No.
Create an elastic pool.
- Use the server from the SQL database creation.
- Choose the Basic tier with 50 eDTUs.
- Attach and Manage an Elastic Pool
Attach both databases to the elastic pool.
Review the available monitoring options to determine resource utilization.
Detach the databases and de-provision the pool.
