From the course: Implementing a Data Warehouse with SQL Server 2022
Join today to access over 24,900 courses taught by industry experts.
Reserve resources with workload isolation groups - SQL Server Tutorial
From the course: Implementing a Data Warehouse with SQL Server 2022
Reserve resources with workload isolation groups
- [Instructor] My dedicated SQL pool has just finished deploying to my Azure account and I can see it here on the main dashboard. Now, within the SQL pool memory and CPU resources are going to be shared across all of the users of the database. In order to prioritize certain activities, you can set up workload isolation groups. This will reserve a portion of your resource allocations for specific tasks such as loading new data into the pool. That way regular data loads can be performed more predictably, and they won't be impacted by heavy analysis workloads that may be operating at the same time a load is scheduled to occur. Without workload isolation, everyone gets a slice of these same shared resources and service levels will not be guaranteed for any one activity. To configure workload isolation from the Azure portal, start here at the main dashboard and then click the link for the new dedicated resource pool that was just…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.