Announcing Skill Me Up Live! Sign up today and save 60% on your first month using offer code LIVETRAINING at checkout.
Managing Elastic Database Pools in Azure SQL Database
Lab
Advanced
1 h 25 m
2018-10-10
Lab Overview

In this lab, we will walk through management and monitoring of an Elastic Pool. First, we will create an Elastic Pool and add our databases to the pool. Then we will monitor the performance of our pool using TSQL Scripts and the Azure Portal.

Objectives
  • Managing Azure SQL Database Elastic Pools.
  • Monitoring Elastic Database Pools using the Azure Portal.
  • Troubleshooting Elastic Database Pool resource consumption using Database Management Views.
Pre-Requisites
  • Previous experience with SQL Server or Azure SQL Database
Exercises
In this exercise, you will create an Elastic Pool on an existing Logical SQL Server. You will add four databases to the pool and configure your client machine to connect to the Logical SQL Server.
In this exercise, we will setup and configure monitoring for an elastic database pool to pinpoint a database that is having performance issues. We will then reallocate pool resources to accommodate this databases coexistence in the pool
Real-Time Lab
Not Registered?
Create Account
Already Registered?
Login
What are Labs?

Labs are where you can get hands on experience from what you have learned from lectures. You get to work in real time in virtual machines at your pace.