Cybrary Pro Day is here!

Optimizing Query Plans Part 2

Practice Labs Module
Time
37 minutes
Difficulty
Intermediate

The Optimizing Query Plans module provides you with the instructions and devices to develop your hands on skills in the following topic: Working with Azure SQL database performance insight.

Join over 3 million cybersecurity professionals advancing their career
Sign up with
or

Already have an account? Sign In »

Overview

Introduction

The Optimizing Query Plans module provides you with the instructions and devices to develop your hands on skills in the following topic.

  • Working with Azure SQL database performance insight

Lab time: It will take approximately 30 minutes to complete this lab.

Exam Objectives

One exam objective is covered in this lab.

  • Demonstrate the steps used to configure Azure SQL Database Performance Insight

Exercise 1 - Working with Azure SQL Database Performance Insight

There are many tools in Azure SQL database that help to improve the database performance. Some of them are Performance Overview, SQL Database Advisor, and Query Performance Insight.

The Performance Overview tool provides a summary of the entire database performance. You can use the summarized data to diagnose and troubleshoot performance related issues.

The Query Performance Insight tool provides you with the query details such as the text and resource utilization. It helps to determine the top resource consuming queries based on the CPU performance, execution count, and duration. It also helps to determine the query workload and the database resource consumption. You must activate the Query Store feature in your database to use the Query Performance Insight tool in Azure portal.

In this exercise, you will learn to create a new Microsoft Azure account and configure the Azure SQL database Query Performance Insight.

Learning Partner
Comprehensive Learning

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