Invalid Login Attempt

Lab: Managing Elastic Database Pools in Azure SQL Database

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.


Details
  • Estimated time required to complete: 1 hours, 25 minutes
  • You will have access to this environment for 4 hours, 0 minutes
  • Learning Credits Required: 5
Who this lab is designed for
  • Database Developers
  • Database Administrators
  • Database Architects

Learning 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

Exercise 2: Creating an Elastic Pool
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.
Exercise 3: Monitoring Performance of an Elastic Database Pool
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

Login to Start Lab


Not Registered? Already Registered?
Benefits
Real Time Labs allow you to learn technology in an isolated environment without the hassle or cost of setting up a dedicated learning environment.

How it works