Skip to main content

Managing Elastic Pools and Pooled Databases in Azure

Hands-On Lab

 

Photo of Brian  Roehm

Brian Roehm

Azure Training Architect I in Content

Length

00:45:00

Difficulty

Beginner

In this hands-on lab, we will learn how to create an elastic pool and tie databases to that pool using the Azure Portal.

What are Hands-On Labs?

Hands-On Labs are scenario-based learning environments where learners can practice without consequences. Don't compromise a system or waste money on expensive downloads. Practice real-world skills without the real-world risk, no assembly required.

Managing Elastic Pools and Pooled Databases in Azure

Introduction

In this hands-on lab, we will learn how to create an elastic pool and attach databases to that pool using the Azure Portal.

Log In to the Environment

  1. Install SQL Server Management Studio or Azure Data Studio using the links provided on the lab instructions page.
  2. On the main lab page, click the Open Azure Portal button.
  3. Enter the username that was provided for you in the Credentials section of the lab instructions page.
  4. Click Next.
  5. Enter the password that was provided for you in the Credentials section of the lab instructions page.
  6. Click Next.
  7. In the Welcome menu, click Maybe later.

Create Two SQL Databases

Create a SQL Database

  1. Click SQL databases in the left sidebar.
  2. Click Create sql database.
  3. For Resource group, click into the dropdown and select the existing group.
  4. For Database name, enter "lalearning1".
  5. Under Server, click Create new.
  6. In the New server menu, configure the following settings:
    • Server name: (Enter a unique name.)
    • Server admin login: (Enter a unique name.)
    • Password: Test123456
    • Confirm password: Test123456
    • Location: (US) East (US)
  7. Click Select.
  8. For Want to use SQL elastic pool?, select No.
  9. Under Compute + storage, click Configure database.
  10. Click the Basic tier tab.
  11. Set Data max size to 100 MB.
  12. Click Apply.
  13. Click Review + create.
  14. Click Create.
  15. Click the bell icon at the top of the page to open the Notifications menu.
  16. Click Deployment in progress, and wait for the deployment to finish deploying.
  17. Click All resources in the left sidebar to view the SQL database we just created.

Create a Second SQL Database

  1. Click SQL databases in the left sidebar.
  2. Click Create sql database.
  3. For Resource group, click into the dropdown and select the existing group.
  4. For Database name, enter "lalearning2".
  5. Leave the Server field autopopulated with lalearning1.
  6. For Want to use SQL elastic pool?, select No.
  7. Under Compute + storage, click Configure database.
  8. Click the Basic tier tab.
  9. Set Data max size to 100 MB.
  10. Click Apply.
  11. Click Review + create.
  12. Click Create.
  13. Click the bell icon at the top of the page to open the Notifications menu.
  14. Note that there are now two deployments listed.

Create an Elastic Pool

  1. Click All resources in the left sidebar.
  2. In the search bar at the top of the page, search for "elastic".
  3. Select SQL elastic pools.
  4. Click Create sql elastic pool.
  5. In the Elastic pool menu, name the pool "lalearning".
  6. Click Configure pool.
  7. Click the Basic tier tab.
  8. Set the eDTUs to 50.
  9. Click Apply.
  10. Click Create.
  11. Wait a few minutes for the elastic pool to spin up.

Attach the Databases to the Elastic Pool

  1. Click All resources in the left sidebar.
  2. Click the name of the elastic pool to open it.
  3. Under Elastic databases, click 0 databases.
  4. Click + Add databases.
  5. Click the checkboxes to select both databases.
  6. Click Apply.
  7. Click Save.

View the Resource Utilization

  1. Click Overview in the lalearning menu.
  2. Click 2 databases.
  3. Under Monitoring, click Database Resource Utilization.
  4. Review the available monitoring options.

Detach the Databases and De-Provision the Pool

  1. In the lalearning menu, click Overview.
  2. Click 2 databases.
  3. Under DATABASE NAME, click the checkboxes to select both databases.
  4. Click X Remote from pool.
  5. Click Save.
  6. Wait a few minutes for the deployment to finish.
  7. When the deployment is finished and the databases have been removed, click Overview.
  8. Click Delete.
  9. Under Are you sure you want to delete lalearning?, enter "lalearning" to confirm.
  10. Click All resources in the left sidebar.
  11. Verify that the elastic pool has been deleted.

Conclusion

Congratulations, you've successfully completed this hands-on lab!