Lab: Managing Elastic Database Pools in Azure SQL Database
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.
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
Managing Azure SQL Database Elastic Pools.
Monitoring Elastic Database Pools using the Azure Portal.
Troubleshooting Elastic Database Pool resource consumption using Database Management Views.
Previous experience with SQL Server or Azure SQL Database
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?
Real Time Labs allow you to learn technology in an isolated environment without the hassle or cost of setting up a dedicated learning environment.