Azure Synapse Analytics | Workload Management and Concurrency

In any data warehouse system, there are different types of workloads – in broad categories, we can say there is one to load and process data, and there is another one for data querying. Even within these broad categories, there might be few requests which require high importance and more resources than others. For example, there might be critical data load which needs to be completed within tight SLA with high priority, yet there might be other data load which can wait or okay to take longer. Likewise, there might be some queries which have higher priority than others, for example the ones which are coming from your leadership teams for timely decision making than day to day operational reports.

In this video, you will learn about workload management, what it is, what are options and how it works in dedicated SQL pool.

00:00 Workload Management - Introduction
01:04 Resource Classes - Static vs Dynamic Resource Classes
06:56 Workload Management - New Feature
08:25 Workload Management - Isolation
09:27 Workload Management - Classification
10:28 Workload Management - Importance
14:25 Demo - Resource Classes
20:53 Demo - Workload Management (Isolation, Importance and Classification)

Thank you for watching, in my next video, I am going to talk in detail about different data ingestion patterns and options available when working with SQL pool. Stay tuned.

GitHub Repo to download deck and script used in the video:
https://github.com/AasTrailblazers/Az...

What is workload management?
https://docs.microsoft.com/en-us/azur...

Workload management with resource classes in Azure Synapse Analytics
https://docs.microsoft.com/en-us/azur...