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.

Comprehensive Learning

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