From the course: Implementing a Data Warehouse with SQL Server 2022
Join today to access over 24,800 courses taught by industry experts.
Classify workloads - SQL Server Tutorial
From the course: Implementing a Data Warehouse with SQL Server 2022
Classify workloads
- [Instructor] Now that we have a workload isolation group created, we need to classify workloads so that they use the appropriate resource allocations that we've just set up. To do this, we first need to create a new user account on the database. And the easiest way to do that is by executing tSQL commands on the server. So let's connect using Management Studio. If you're still on the workload management page for the dedicated SQL pool, switch over to the Overview page. At the top, you'll find the fully qualified server name that we need to use in order to connect. If you hover your mouse over the link, you'll see a little copy icon up here to the right. Go ahead and click that and that'll copy that to your clipboard. Then we can go into Management Studio. From here, I'll click the plug icon at the top of the object explorer to open up the connect to server dialogue window. For the server name, I'll paste in that…
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.