ResourcePool

New-DbaRgResourcePool

John McCall (@lowlydba), lowlydba.com

New-DbaRgResourcePool View Source John McCall (@lowlydba), lowlydba.com Windows, Linux, macOS Synopsis Creates a Resource Governor resource pool to control CPU, memory, and I/O allocation for SQL Server workloads. Description Creates a new Resource Governor resource pool that defines specific limits for CPU, memory, and I/O resources on a SQL Server instance. Resource pools let you isolate different workloads by setting minimum and maximum thresholds for system resources, preventing one application from consuming all server resources.

Remove-DbaRgResourcePool

John McCall (@lowlydba), lowlydba.com

Remove-DbaRgResourcePool View Source John McCall (@lowlydba), lowlydba.com Windows, Linux, macOS Synopsis Removes internal or external resource pools from SQL Server Resource Governor configuration Description Removes user-defined resource pools from SQL Server’s Resource Governor, freeing up the allocated memory, CPU, and IO resources for redistribution to other workloads. This is typically done when cleaning up unused resource pools, consolidating workload management, or reconfiguring resource allocation strategies. Resource pools define the physical resource boundaries (memory, CPU, IO) that can be assigned to different database workloads through workload groups.

Set-DbaRgResourcePool

John McCall (@lowlydba), lowlydba.com

Set-DbaRgResourcePool View Source John McCall (@lowlydba), lowlydba.com Windows, Linux, macOS Synopsis Modifies CPU, memory, and IOPS limits for existing SQL Server Resource Governor pools. Description Modifies resource allocation settings for existing Resource Governor pools to control how much CPU, memory, and disk I/O different workloads can consume. This lets you adjust performance limits after analyzing workload patterns or when server capacity changes. Works with both internal pools (for SQL Server queries) and external pools (for R Services, Python, or other external processes).

Set-DbaRgWorkloadGroup

John McCall (@lowlydba), lowlydba.com

Set-DbaRgWorkloadGroup View Source John McCall (@lowlydba), lowlydba.com Windows, Linux, macOS Synopsis Modifies Resource Governor workload group settings to control query resource consumption and limits. Description Modifies configuration settings for Resource Governor workload groups, which control how SQL Server allocates CPU, memory, and parallelism resources to different categories of queries and connections. Use this function to adjust resource limits for specific workload groups when you need to prioritize critical applications, limit resource-hungry queries, or enforce service level agreements through resource allocation policies.