Monitoring an Azure SQL database using the Azure portal

Azure SQL Database has built-in monitoring features, such as Query Performance Insights, performance overview, and diagnostic logging. In this recipe, we’ll learn how to use the monitoring capabilities using the Azure portal.

Getting ready

We’ll use PowerShell to create an Azure SQL database, so open a PowerShell window and log in to your Azure account by executing the Connect-AzAccount command.

We’ll use the Azure portal to monitor the Azure SQL database. Open https://portal.azure.com and log in to your Azure account.

How to do it…

First, let’s execute a sample workload.

Creating an Azure SQL database and executing a sample workload

The steps are as follows:

1. Execute the following PowerShell command to create an Azure SQL database using the AdventureWorksLT sample database:

   # create the resource group
   New-AzResourceGroup -Name packtadesql -Location "central us...