WorkloadGroup

New-DbaRgWorkloadGroup

John McCall (@lowlydba), lowlydba.com

New-DbaRgWorkloadGroup View Source John McCall (@lowlydba), lowlydba.com Windows, Linux, macOS 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. Workload groups act as containers that classify incoming requests and apply resource policies like CPU time limits, memory grant percentages, and maximum degree of parallelism.

Remove-DbaRgWorkloadGroup

John McCall (@lowlydba), lowlydba.com

Remove-DbaRgWorkloadGroup View Source John McCall (@lowlydba), lowlydba.com Windows, Linux, macOS 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. Useful for cleaning up test environments, removing deprecated resource policies, or simplifying Resource Governor configurations during performance tuning.