Building monitoring dashboards for Synapse with Azure Monitor

By default, Azure Monitor stores the key performance counters of Synapse SQL pools and Sparks pool. Creating a dashboard using Azure Monitor’s performance counters allows you to observe all the key performance counters at a glance and deduct any health-related issues on the Synapse workspace.

Getting ready

The prerequisites for this recipe are as follows:

• Create a Synapse Analytics workspace, as explained in the Provisioning an Azure Synapse Analytics workspace recipe of Chapter 8, Processing Data Using Azure Synapse Analytics.
• Complete the Loading data into a dedicated SQL pool using PolyBase and T-SQL recipe of Chapter 10, Building the Serving Layer in Azure Synapse SQL Pool to create a dedicated SQL pool named packtadesqlpool, an external table named dbo.ext_transaction_tbl, and a dedicated SQL pool table named dbo.transaction_tbl.
• Download the SQLPool_Queries.sql script from https://github...