Copy-DbaResourceGovernor View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Copies SQL Server Resource Governor configuration including pools, workload groups, and classifier functions between instances
Description Migrates your entire SQL Server Resource Governor setup from one instance to another, including custom resource pools, workload groups, and classifier functions. This saves you from manually recreating complex Resource Governor configurations when setting up new servers or during migrations.
The function copies all non-system resource pools (excludes the built-in “internal” and “default” pools) along with their associated workload groups and settings.
Get-DbaResourceGovernor View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Retrieves Resource Governor configuration and status from SQL Server instances
Description Retrieves the Resource Governor object containing configuration details, enabled status, and associated resource pools. Resource Governor allows DBAs to manage SQL Server workload and resource consumption by setting limits on CPU, memory, and I/O usage for different workloads. This function helps you quickly check if Resource Governor is enabled, view classifier functions, and examine current resource pool configurations without writing custom T-SQL queries.
Get-DbaRgClassifierFunction View Source Alessandro Alpi (@suxstellino), alessandroalpi.blog Windows, Linux, macOS Synopsis Retrieves the Resource Governor classifier function configured for workload group assignment
Description Retrieves the custom classifier function that Resource Governor uses to determine which workload group incoming connections are assigned to. The classifier function contains the business logic that evaluates connection properties (like login name, application name, or host name) and returns the appropriate workload group name. This function is always stored in the master database and is essential for understanding how Resource Governor categorizes and manages SQL Server workloads.
Get-DbaRgResourcePool View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Retrieves SQL Server Resource Governor resource pools with their CPU, memory, and IOPS configuration settings
Description Retrieves detailed information about SQL Server Resource Governor resource pools, including both internal (CPU/memory) and external (R/Python) pools. Shows current configuration settings for minimum and maximum CPU percentages, memory percentages, and IOPS limits per volume. Essential for monitoring resource allocation, troubleshooting performance bottlenecks, and auditing resource governance policies across your SQL Server instances.
Get-DbaRgWorkloadGroup View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Retrieves Resource Governor workload groups from SQL Server instances
Description Retrieves Resource Governor workload groups along with their configuration settings including CPU limits, memory grants, and parallelism controls. Workload groups define how resource requests are classified and managed within resource pools, allowing DBAs to control resource consumption for different types of workloads. This function is essential for monitoring and troubleshooting Resource Governor configurations to ensure optimal performance isolation between competing workloads.
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.
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-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.
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.
Set-DbaResourceGovernor View Source John McCall (@lowlydba), lowlydba.com Windows, Linux, macOS Synopsis Configures SQL Server Resource Governor to control workload resource allocation and sets classifier functions.
Description Configures Resource Governor settings at the SQL Server instance level to control CPU, memory, and I/O resource allocation for different workloads. Resource Governor requires both being enabled on the instance and having an optional classifier function that determines which resource pool and workload group incoming sessions should use based on login properties, application name, or other criteria.
dbatools