Overview

Introduction

The Optimizing Performance for Database Instances module provides you with the instructions and devices to develop your hands on skills in the following topics.

  • Working with elastic scale pool for Azure SQL database
  • Working with Azure SQL database query plans

Exam Objectives

Two lab objectives are covered in this lab.

  • Demonstrate how to create an Elastic scale pool for Azure SQL Database
  • Demonstrate how to get information on Azure SQL Database query plans

Exercise 1 - Working with Elastic Scale Pool for Azure SQL Database

The elastic scale pool feature of Azure SQL database helps to manage and simplify data management. This feature is particularly useful to Software as a Service (SaaS) developers. In SaaS environment, huge databases need to be managed for dynamic customer data. Therefore, elastic pools in Azure SAL database enable the SaaS developers to deliver performance elasticity and optimize the pricing for databases.

In this exercise, you will learn to first learn to create a new Microsoft Azure account and then create and deploy the Azure SQL database with elastic scale pool feature.

Exercise 2 - Working with Azure SQL Database Query Plans

You can understand query performance in Windows Azure SQL Databases by connecting and working with Azure SQL databases using Visual Studio.

In this exercise, you will use Visual Studio to connect with the TestDB Azure SQL database. You will execute a SQL query on the TestDB database tables and learn how to view the execution plans for the generated query in Visual Studio.

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.