Implementing workload management in an Azure Synapse SQL pool
A data warehouse usually has mixed workloads, such as data import or data warehouse updates, reporting queries, aggregation queries, and data export. Running all of these queries in parallel results in resource challenges in the data warehouse.
Workload management uses workload classification, workload importance, and isolation to provide better control over how the workload uses the system resources.
In this recipe, we'll learn how to prioritize a workload using Windows classifiers and importance.
Getting ready
Before you start, open SSMS and log in to Azure SQL Server.
You need a Synapse SQL pool to perform the steps in this recipe. If you don't have an existing Synapse SQL pool, you can create one using the steps from the Provisioning and connecting to an Azure Synapse SQL pool using PowerShell recipe.
The recipe requires the orders
table in the Synapse SQL pool. If you don't have...