In this challenge, you will optimize query performance in an Azure SQL database. First, you will create an Azure virtual machine that hosts SQL Server, and then you will create an Azure SQL database. Next, you will verify the Query Store configuration on the Azure SQL database, and then you will generate some test data in the Azure SQL database. Finally, you will add an index for query performance, and then use Query Performance Insight to analyze query performance. Note: Once you begin the challenge, you will not be able to pause, save, or exit and then return to your challenge. Please ensure that you have set aside enough time to complete the challenge before you start.
Learning Objectives
In this challenge, you will optimize query performance in an Azure SQL database. First, you will create an Azure virtual machine that hosts SQL Server, and then you will create an Azure SQL database. Next, you will verify the Query Store configuration on the Azure SQL database, and then you will generate some test data in the Azure SQL database. Finally, you will add an index for query performance, and then use Query Performance Insight to analyze query performance. Note: Once you begin the challenge, you will not be able to pause, save, or exit and then return to your challenge. Please ensure that you have set aside enough time to complete the challenge before you start.