ResourceGovernor

Set-DbaRgResourcePool

John McCall (@lowlydba), lowlydba.com

Set-DbaRgResourcePool View Source John McCall (@lowlydba), lowlydba.com Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.

Set-DbaRgWorkloadGroup

John McCall (@lowlydba), lowlydba.com

Set-DbaRgWorkloadGroup View Source John McCall (@lowlydba), lowlydba.com Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.