Watch one module per day and complete the assignment at your pace.
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.1. Workload Management - Introduction2.Resource Classes - Static vs Dynamic Resource Classes3.Workload Management - New Feature4.Workload Management - Isolation5.Workload Management - Classification6.Workload Management - Importance7.Demo - Resource Classes8.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.
CloseYou have requested to attent Azure Synapse Analytics | Workload Management and Concurrency.
Attend