WorkloadGroup

New-DbaRgWorkloadGroup

John McCall (@lowlydba), lowlydba.com

New-DbaRgWorkloadGroup View Source John McCall (@lowlydba), lowlydba.com Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Creates a Resource Governor workload group within a specified resource pool to control SQL Server resource allocation. Description Creates a Resource Governor workload group within a specified resource pool, allowing you to define specific resource limits and priorities for different types of SQL Server workloads.

Remove-DbaRgWorkloadGroup

John McCall (@lowlydba), lowlydba.com

Remove-DbaRgWorkloadGroup View Source John McCall (@lowlydba), lowlydba.com Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Removes workload groups from SQL Server Resource Governor Description Removes specified workload groups from SQL Server Resource Governor and automatically reconfigures the Resource Governor so changes take effect immediately. Workload groups define resource allocation policies for incoming requests, and removing them eliminates those resource controls.